ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Heterogeneous replication and XStreams support for GoldenGate
AUTHID
CURRENT_USER
Dependencies
DBMS_APPLY_ADM
DBMS_DBFS_SFS_ADMIN
DBMS_STREAMS_DECL
DBMS_APPLY_ADM_INTERNAL
DBMS_LOGREP_UTIL
DBMS_XSTREAM_GG_INTERNAL
DBMS_DBFS_CONTENT_ADMIN
Documented
No
Exceptions
Error Code
Reason
ORA-26947
Oracle GoldenGate replication is not enabled
First Available
11.2
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Direct access to some objects in this package is prevented by means of an Accessible By clause.
exec dbms_xstream_gg.disable_tdup_workspace;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 308
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 85
ORA-06512: at line 1
Generates an error if GG replication is not enabled
dbms_xstream_gg.enable_tdup_workspace;
exec dbms_xstream_gg.enable_tdup_workspace;
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 290
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 54
ORA-06512: at line 1
BEGIN
IF dbms_xstream_gg.is_ctas_no_dml_at_session THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 348
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 274
ORA-06512: at line 2
BEGIN
IF dbms_xstream_gg.is_foo_trigger_fire_at_session THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 264
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 28
ORA-06512: at line 2
BEGIN
IF dbms_xstream_gg.is_tdup_workspace_enabled THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 299
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 70
ORA-06512: at line 2
dbms_xstream_gg.set_ctas_session_context('suppress_dml IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_ctas_session_context(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 339
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 259
ORA-06512: at line 1
dbms_xstream_gg.set_foo_trigger_session_contxt(fire IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_foo_trigger_session_contxt(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 255
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 13
ORA-06512: at line 1
dbms_xstream_gg.set_gg_no_stmt_buf(set IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 162
ORA-06512: at line 1
dbms_xstream_gg.set_gg_no_ws_for_def_cons(set IN BOOLEAN);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_no_ws_for_def_cons(FALSE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 232
ORA-06512: at line 1
exec dbms_xstream_gg.set_gg_session(FALSE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 135
ORA-06512: at line 1
dbms_xstream_gg.set_gg_session_flags(
gg_flags IN BINARY_INTEGER,
smode IN BINARY_INTEGER);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_session_flags(1,1);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at line 1
dbms_xstream_gg.set_gg_xml_schema(set IN BOOLEAN);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_xml_schema(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 197
ORA-06512: at line 1
SET_SESSION_ACTION_GG
Undocumented
dbms_xstream_gg.set_session_action_gg(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
action_type IN VARCHAR2,
action_options IN NUMBER,
xid_usn IN NUMBER,
xid_slt IN NUMBER,
xid_sqn IN NUMBER,
thread# IN NUMBER,
start_scn IN NUMBER,
start_sub_scn IN NUMBER,
end_scn IN NUMBER,
end_sub_scn IN NUMBER,
rba_sqn IN NUMBER,
rba_blk IN NUMBER,
rba_byte IN NUMBER,
session# IN NUMBER,
obj# IN NUMBER,
attr1 IN NUMBER,
attr2 IN NUMBER,
attr3 IN NUMBER);
TBD
UNSET_SESSION_ACTION_GG
Undocumented
dbms_xstream_gg.unset_session_action_gg(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
force IN BOOLEAN);