Oracle DBMS_XSTREAM_GG
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Heterogeneous replication and GoldenGate
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_DBFS_CONTENT_ADMIN DBMS_STREAMS_DECL
DBMS_APPLY_ADM_INTERNAL DBMS_DBFS_SFS_ADMIN DBMS_XSTREAM_GG_INTERNAL
DBMS_APPLY_HANDLER_INTERNAL DBMS_LOGREP_UTIL  
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_CHARSET_COMP_FOR_MINING (new 12.2)
Undocumented dbms_xstream_gg.is_charset_comp_for_mining(charset_name IN VARCHAR2) RETURN NUMBER;
SQL> SELECT dbms_xstream_gg.is_charset_comp_for_mining('AL32UTF8')
2 FROM dual;

DBMS_XSTREAM_GG.IS_CHARSET_COMP_FOR_MINING('AL32UTF8')
------------------------------------------------------
                                                     1
 
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
 
SET_SESSION_ACTION_GG (new 12.2)
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 (new 12.2)
Undocumented dbms_xstream_gg.unset_session_action_gg(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
force           IN BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_GOLDENGATE_AUTH
GoldenGate
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