Oracle DBMS_XSTREAM_GG
Version 26ai

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

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
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