Oracle DBMS_XSTREAM_GG
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Heterogeneous replication and GoldenGate
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_APPLY_HANDLER_INTERNAL DBMS_STREAMS_DECL
DBMS_APPLY_ADM_INTERNAL DBMS_LOGREP_UTIL DBMS_XSTREAM_GG_INTERNAL
Documented No
Exceptions
Error Code Reason
ORA-26947 Oracle GoldenGate replication is not enabled
First Available 11.2.0.3
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
 
DISABLE_TDUP_WORKSPACE
Undocumented

Generates an error if not executed by the correct internal program
dbms_xstream_gg.disable_tdup_workspace;
exec dbms_xstream_gg.disable_tdup_workspace;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 246
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 74
ORA-06512: at line 1
 
ENABLE_TDUP_WORKSPACE
Undocumented

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 228
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 43
ORA-06512: at line 1
 
GET_GG_NO_STMT_BUF
Undocumented dbms_xstream_gg.get_gg_no_stmt_buf RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.get_gg_no_stmt_buf THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
GET_GG_NO_WS_FOR_DEF_CONS
Undocumented dbms_xstream_gg.get_gg_no_ws_for_def_cons RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.get_gg_no_ws_for_def_cons THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
GET_GG_SESSION
Returns False if the current session is not running GoldenGate dbms_xstream_gg.get_gg_session RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.get_gg_session THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
GET_GG_SESSION_FLAGS
Undocumented dbms_xstream_gg.get_gg_session_flags RETURN BINARY_INTEGER;
SELECT dbms_xstream_gg.get_gg_session_flags
FROM dual;

GET_GG_SESSION_FLAGS
--------------------
                   0
 
GET_GG_XML_SCHEMA
Undocumented dbms_xstream_gg.get_gg_xml_schema RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.get_gg_xml_schema THEN
    dbms_output.put_line('Enabled');
  ELSE
    dbms_output.put_line(' Not Enabled');
  END IF;
END;
/
Not Enabled

PL/SQL procedure successfully completed.
 
IS_CTAS_NO_DML_AT_SESSION
Undocumented dbms_xstream_gg.is_ctas_no_dml_at_session RETURN BOOLEAN;
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 286
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 263
ORA-06512: at line 2
 
IS_FOO_TRIGGER_FIRE_AT_SESSION
Undocumented dbms_xstream_gg.is_foo_trigger_fire_at_session RETURN BOOLEAN;
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 219
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 28
ORA-06512: at line 2
 
IS_TDUP_WORKSPACE_ENABLED
Undocumented dbms_xstream_gg.is_tdup_workspace_enabled RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.is_tdup_workspace_enabled THEN
    dbms_output.put_line('Enabled');
nbsp; 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 237
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 59
ORA-06512: at line 2
 
SET_CTAS_SESSION_CONTEXT
Undocumented dbms_xstream_gg.set_ctas_session_context('suppress_dml IN BOOLEAN);
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 277
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 248
ORA-06512: at line 1
 
SET_FOO_TRIGGER_SESSION_CONTXT
Undocumented dbms_xstream_gg.set_foo_trigger_session_contxt(fire IN BOOLEAN);
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 210
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 13
ORA-06512: at line 1
 
SET_GG_NO_STMT_BUF
Undocumented dbms_xstream_gg.set_gg_no_stmt_buf(set IN BOOLEAN);
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 258
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 151
ORA-06512: at line 1
 
SET_GG_NO_WS_FOR_DEF_CONS
Undocumented dbms_xstream_gg.set_gg_no_ws_for_def_cons(set IN BOOLEAN);
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 258
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 221
ORA-06512: at line 1
 
SET_GG_SESSION
Undocumented dbms_xstream_gg.set_gg_session(set IN BOOLEAN);
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 258
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 124
ORA-06512: at line 1
 
SET_GG_SESSION_FLAGS
Undocumented dbms_xstream_gg.set_gg_session_flags(
gg_flags IN BINARY_INTEGER,
smode    IN BINARY_INTEGER);
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 258
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at line 1
 
SET_GG_XML_SCHEMA
Undocumented dbms_xstream_gg.set_gg_xml_schema(set IN BOOLEAN);
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 258
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 186
ORA-06512: at line 1

Related Topics
DBMS_GOLDENGATE_AUTH
GoldenGate
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved