Oracle DBMS_XSTREAM_GG
Version 21c

General Information
Library Note Morgan's Library Page Header
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.
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
DISABLE_TDUP_WORKSPACE IS_CHARSET_COMP_FOR_MINING SET_GG_NO_WS_FOR_DEF_CONS
ENABLE_TDUP_WORKSPACE IS_CTAS_NO_DML_AT_SESSION SET_GG_SESSION
GET_GG_NO_STMT_BUF IS_FOO_TRIGGER_FIRE_AT_SESSION SET_GG_SESSION_FLAGS
GET_GG_NO_WS_FOR_DEF_CONS IS_TDUP_WORKSPACE_ENABLED SET_GG_XML_SCHEMA
GET_GG_SESSION SET_CTAS_SESSION_CONTEXT SET_SESSION_ACTION_GG
GET_GG_SESSION_FLAGS SET_FOO_TRIGGER_SESSION_CONTXT UNSET_SESSION_ACTION_GG
GET_GG_XML_SCHEMA SET_GG_NO_STMT_BUF  
 
DISABLE_TDUP_WORKSPACE
Undocumented

Protected by an ACCESSIBLE BY clause		 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 308
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 85
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 290
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 54
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
Undocumented dbms_xstream_gg.is_charset_comp_for_mining(charset_name IN VARCHAR2) RETURN NUMBER;
SELECT dbms_xstream_gg.is_charset_comp_for_mining('AL32UTF8')
FROM dual;

DBMS_XSTREAM_GG.IS_CHARSET_COMP_FOR_MINING('AL32UTF8')
------------------------------------------------------
                                                     1
 
IS_CTAS_NO_DML_AT_SESSION
Undocumented

Protected by an ACCESSIBLE BY clause		 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 348
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 274
ORA-06512: at line 2
 
IS_FOO_TRIGGER_FIRE_AT_SESSION
Undocumented

Protected by an ACCESSIBLE BY clause		 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 264
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 28
ORA-06512: at line 2
 
IS_TDUP_WORKSPACE_ENABLED
Undocumented

Protected by an ACCESSIBLE BY clause		 dbms_xstream_gg.is_tdup_workspace_enabled RETURN BOOLEAN;
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
 
SET_CTAS_SESSION_CONTEXT
Undocumented 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
 
SET_FOO_TRIGGER_SESSION_CONTXT
Undocumented 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
 
SET_GG_NO_STMT_BUF
Undocumented 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
 
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_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
 
SET_GG_SESSION
Undocumented dbms_xstream_gg.set_gg_session(set IN BOOLEAN);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);

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
 
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_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
 
SET_GG_XML_SCHEMA
Undocumented 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);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_ADM_INTERNAL
DBMS_GOLDENGATE_AUTH
DBMS_GOLDENGATE_EXP
DBMS_GOLDENGATE_IMP
DBMS_XSTREAM_ADM
DBMS_XSTREAM_GG_INTERNAL
GoldenGate
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx