Oracle DBMS_XSTREAM_GG
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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, OGG_APPLY, OGG_CAPTURE, XSTREAM_APPLY and XSTREM_CAPTURE roles.

Access to some subpograms prevented by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
ADD_PROCEDURETRANDATA GET_GG_SHARED_CAPTURE SET_GG_NO_STMT_BUF
DISABLE_TDUP_WORKSPACE GET_GG_XML_SCHEMA SET_GG_NO_WS_FOR_DEF_CONS
DROP_PROCEDURETRANDATA IS_CHARSET_COMP_FOR_MINING SET_GG_SESSION
ENABLE_TDUP_WORKSPACE IS_CTAS_NO_DML_AT_SESSION SET_GG_SESSION_FLAGS
GET_GG_COMPAT_FLAGS IS_FOO_TRIGGER_FIRE_AT_SESSION SET_GG_XML_SCHEMA
GET_GG_NO_STMT_BUF IS_TDUP_WORKSPACE_ENABLED SET_SESSION_ACTION_GG
GET_GG_NO_WS_FOR_DEF_CONS SET_CTAS_SESSION_CONTEXT SWITCH_LOGFILE
GET_GG_SESSION SET_FOO_TRIGGER_SESSION_CONTXT UNSET_SESSION_ACTION_GG
GET_GG_SESSION_FLAGS    
 
ADD_PROCEDURETRANDATA (new 23ai)
Undocumented dbms_xstream_gg.add_procedureTrandata;
exec dbms_xstream_gg.add_procedureTrandata;

PL/SQL procedure_successfully completed.
 
DISABLE_TDUP_WORKSPACE
Undocumented dbms_xstream_gg.disable_tdup_workspace;
exec dbms_xstream_gg.disable_tdup_workspace;
     *
ORA-01031: insufficient privileges
 
DROP_PROCEDURETRANDATA (new 23ai)
Undocumented dbms_xstream_gg.drop_procedureTrandata;
exec dbms_xstream_gg.drop_procedureTrandata;

PL/SQL procedure_successfully completed.
 
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;
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
GET_GG_COMPAT_FLAGS (new 23ai)
Undocumented dbms_xstream_gg.get_ggg_compat_flags RETURN BINARY_INTEGER;
SELECT dbms_xstream_gg.get_ggg_compat_flags;

GET_GG_COMPAT_FLAGS
-------------------
                 15
 
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;

GET_GG_SESSION_FLAGS
--------------------
                   0
 
GET_GG_SHARED_CAPTURE (new 23ai)
Undocumented dbms_xstream_gg.get_gg_shared_capture RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg.get_gg_shared_capture THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
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');

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;
/
*
ORA-01031: insufficient privileges
 
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;
/
*
ORA-01031: insufficient privileges
 
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');
  ELSE
    dbms_output.put_line(' Not Enabled');
  END IF;
END;
/
*
ORA-01031: insufficient privileges
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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);
     *
ORA-26947: Oracle GoldenGate replication is not enabled.
 
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
 
SWITCH_LOGFILE (new 23ai)
Undocumented dbms_xstream_gg.switch_logfile(all_log_files IN BOOLEAN);
exec dbms_xstream_gg.switch_logfile(TRUE);

PL/SQL procedure_successfully completed.
 
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 26ai

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