Oracle | DBMS_XSTREAM_GG

Oracle DBMS_XSTREAM_GG_INTERNAL 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 XStreams support for GoldenGate

AUTHID DEFINER

Dependencies

APPLY$_CDR_INFO	DBMS_LOGMNR_INTERNAL	DBMS_XSTREAM_GG
APPLY$_ERROR	DBMS_LOGREP_LIB	DBMS_XSTREAM_GG_ADM
CDB_CAPTURE	DBMS_LOGREP_UTIL	DBMS_XSTREAM_UTL_IVK
DBA_CAPTURE	DBMS_SCHEDULER	PLITBLM
DBA_GOLDENGATE_RULES	DBMS_STANDARD	v$CONTAINERS
DBA_XSTREAM_RULES	DBMS_STREAMS_ADM_UTL_INVOK	V$INSTANCE
DBMS_CAPTURE_ADM_INTERNAL	DBMS_SYSTEM	V$PDBS
DBMS_GOLDENGATE_ADM	DBMS_UTILITY

Documented No

Exceptions

Error Code	Reason
ORA-26947	`Oracle GoldenGate replication is not enabled.`

First Available 12.1

Security Model Owned by SYS with no privileges granted

Access to some subpograms prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb

Subprograms

ADD_DICTIONARY_BUILD_JOB	GET_GG_COMPAT_FLAGS_INT	PURGE_CDR_INFO_INTERNAL
ADD_PROCEDURETRANDATA_INT	GET_GG_SESS_FLAGS_INT	PURGE_TXN_CDR_INFO_INTERNAL
AUTO_DICTIONARY_BUILD	GET_MDH_FOR_PDBNAME_SCN	RESTORE_VARIABLES
BUILD_PDBSET_DICTIONARY	GET_PDBNAME_FOR_MDH	SET_CTAS_SESS_CTX_INT
DISABLE_DICTIONARY_BUILD_JOB	GET_PDB_INFO	SET_FOO_TRIGGER_CONTXT_INT
DISABLE_TDUP_WRKSPC_INT	INIT_WFIT_N_SYNCH_VARS	SET_GG_SESS_FLAGS_INT
DROP_DICTIONARY_BUILD_JOB	IS_CHARSET_COMP_FOR_MINING	SET_SESSION_ACTION
DROP_PROCEDURETRANDATA_INT	IS_CTAS_NO_DML_SESS_INT	SWITCH_LOGFILE_INT
ENABLE_DICTIONARY_BUILD_JOB	IS_FOO_TRIG_FIRE_AT_SESS_INT	UNSET_SESSION_ACTION
ENABLE_TDUP_WORKSPACE_INT	IS_TDUP_WRKSPC_ENABLED_INT	UPDATE_ERROR_TXN

ADD_DICTIONARY_BUILD_JOB (new 23ai)

Undocumented dbms_xstream_gg_internal.add_dictionary_build_job;

TBD

ADD_PROCEDURETRANDATA_INT (new 23ai)

Undocumented dbms_xstream_gg_internal.add_procedureTrandata_int;

TBD

AUTO_DICTIONARY_BUILD (new 23ai)

Undocumented dbms_xstream_gg_internal.auto_dictionary_build;

exec dbms_xstream_gg_internal.auto_dictionary_build;

      

      PL/SQL procedure successfully completed.

BUILD_PDBSET_DICTIONARY

Undocumented dbms_xstream_gg_internal.build_pdbset_dictionary( pdb_names IN dbms_utility.uncl_array, flags IN NUMBER, first_lockdown_scan OUT NUMBER, last_lockdown_scan OUT NUMBER);

ALTER DATABASE FORCE LOGGING;

      

      Database altered.

      

      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

      

      Database altered.

      

      DECLARE

       pdbtab dbms_utility.uncl_array;

       oval1 NUMBER;

       oval2 NUMBER;

      BEGIN

         pdbtab(1) := 'CDB$ROOT';

      

        dbms_xstream_gg_internal.build_pdbset_dictionary(pdbtab, 0, oval1, oval2);

        dbms_output.put_line(oval1);

        dbms_output.put_line(oval2);

      END;

      /

      2459665

      2459665

      

      PL/SQL procedure successfully completed.

DISABLE_DICTIONARY_BUILD_JOB (new 23ai)

Undocumented dbms_xstream_gg_internal.disable_dictionary_build_job;

TBD

DISABLE_TDUP_WRKSPC_INT

Undocumented dbms_xstream_gg_internal.disable_tdup_wrkspc_int;

exec dbms_xstream_gg_internal.disable_tdup_wrkspc_int;

      

      PL/SQL procedure successfully completed

DROP_DICTIONARY_BUILD_JOB (new 23ai)

Undocumented dbms_xstream_gg_internal.drop_dictionary_build_job;

TBD

DROP_PROCEDURETRANDATA_INT (new 23ai)

Undocumented dbms_xstream_gg_internal.drop_procedureTrandata_int;

TBD

ENABLE_DICTIONARY_BUILD_JOB (new 23ai)

Undocumented dbms_xstream_gg_internal.enable_dictionary_build_job;

exec dbms_xstream_gg_internal.enable_dictionary_build_job;

PL/SQL procedure successfully completed.

ENABLE_TDUP_WORKSPACE_INT

Undocumented dbms_xstream_gg_internal.enable_tdup_workspace_int;

exec dbms_xstream_gg_internal.enable_tdup_workspace_int;

           *

      ERROR at line 1:

      ORA-26947: Oracle GoldenGate replication is not enabled.

GET_GG_COMPAT_FLAGS_INT (new 23ai)

Undocumented dbms_xstream_gg_internal.get_gg_compat_flags_int RETURN BINARY_INTEGER;

SELECT dbms_xstream_gg_internal.get_gg_compat_flags_int;

      

      GET_GG_COMPAT_FLAGS_INT

      -----------------------

                           15

GET_GG_SESS_FLAGS_INT

Undocumented dbms_xstream_gg_internal.get_gg_sess_flags_int RETURN BINARY_INTEGER;

SELECT dbms_xstream_gg_internal.get_gg_sess_flags_int;

      

      GET_GG_SESS_FLAGS_INT

      ---------------------

                          0

GET_MDH_FOR_PDBNAME_SCN

Undocumented dbms_xstream_gg_internal.get_mdh_for_pdbname_scn( logmnr_session_num IN NUMBER, pdbname IN VARCHAR2, asofscn IN NUMBER) RETURN NUMBER;

TBD

GET_PDBNAME_FOR_MDH

Undocumented dbms_xstream_gg_internal.get_pdbname_for_mdh( logmnr_session_num IN NUMBER, mdh IN NUMBER) RETURN VARCHAR2;

SELECT dbms_xstream_gg_internal.get_pdbname_for_mdh(1, 1);

      

      DBMS_XSTREAM_GG_INTERNAL.GET_PDBNAME_FOR_MDH(1,1)

      --------------------------------------------------

GET_PDB_INFO

Undocumented dbms_xstream_gg_internal.get_pdb_info( pdb_name IN VARCHAR2, pdb_exists OUT BOOLEAN, pdb_open OUT BOOLEAN, pdb_global_name OUT VARCHAR2, flags OUT BINARY_INTEGER, spare1 OUT NUMBER, spare2 OUT VARCHAR2);

DECLARE

       pdbex  BOOLEAN;

       pdbop  BOOLEAN;

       pdbgn  VARCHAR2(60);

       pdbflg BINARY_INTEGER;

       spVal1 NUMBER;

       spVal2 VARCHAR2(60);

      BEGIN

        dbms_xstream_gg_internal.get_pdb_info('PDBDEV', pdbex, pdbop, pdbgn, pdbflg, spVal1, spVal2);

        IF pdbex THEN

          dbms_output.put_line('PDBDEV Exists');

        END IF;

        IF pdbop THEN

          dbms_output.put_line('PDBDEV Is Open');

        END IF;

        dbms_output.put_line(pdbgn);

        dbms_output.put_line(pdbflg);

        dbms_output.put_line(spVal1);

        dbms_output.put_line(spVal2);

      END;

      /

      PDBDEV Exists

      PDBDEV Is Open

      PDBDEV

      0

      0

INIT_WFIT_N_SYNCH_VARS

Undocumented dbms_xstream_gg_internal.init_wfit_n_synch_vars( input_wfit IN VARCHAR2, input_sync IN VARCHAR2, saved_wfit OUT VARCHAR2, saved_sync OUT VARCHAR2);

TBD

IS_CHARSET_COMP_FOR_MINING

Undocumented dbms_xstream_gg_internal.is_charset_comp_for_mining(canon_charset_name IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

IS_CTAS_NO_DML_SESS_INT

Undocumented dbms_xstream_gg_internal.is_ctas_no_dml_ses_int RETURN BOOLEAN;

BEGIN

        IF dbms_xstream_gg_internal.is_ctas_no_dml_ses_int THEN

          dbms_output.put_line('Whatever it is ... it is TRUE);

        END IF;

      END;

      /

IS_FOO_TRIG_FIRE_AT_SESS_INT

Undocumented dbms_xstream_gg_internal.is_foo_trig_fire_at_sess_int RETURN BOOLEAN;

exec dbms_xstream_gg_internal.is_foo_trig_fire_at_sess_int(FALSE);

IS_TDUP_WRKSPC_ENABLED_INT

Undocumented

This function is likely protected by an ACCESSIBLE BY clause dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int RETURN BOOLEAN;

BEGIN

        IF  dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 299

PURGE_CDR_INFO_INTERNAL

Undocumented dbms_xstream_gg_internal.purge_cdr_info_internal( local_transaction_id IN VARCHAR2, seqno IN NUMBER, rba IN NUMBER, index_num IN NUMBER);

TBD

PURGE_TXN_CDR_INFO_INTERNAL

Undocumented dbms_xstream_gg_internal.purge_txn_cdr_info_internal(local_transaction_id IN VARCHAR2);

TBD

RESTORE_VARIABLES

Undocumented dbms_xstream_gg_internal.restore_variables( wfit IN VARCHAR2, sync IN VARCHAR2, is_ogg IN BOOLEAN);

TBD

SET_CTAS_SESS_CTX_INT

Undocumented dbms_xstream_gg_internal.set_ctas_sess_ctx_int(suppress_DML IN BOOLEAN);

exec dbms_xstream_gg_internal.set_ctas_sess_ctx_int(TRUE);

SET_FOO_TRIGGER_CONTXT_INT

Undocumented dbms_xstream_gg_internal.set_foo_trigger_contxt_int(fire IN BOOLEAN);

exec dbms_xstream_gg_internal.set_foo_trigger_contxt_int(FALSE);

           *

      ERROR at line 1:

      ORA-26947: Oracle GoldenGate replication is not enabled.

SET_GG_SESS_FLAGS_INT

Undocumented dbms_xstream_gg_internal.set_gg_sess_flags_int( gg_flags IN BINARY_INTEGER, smode IN BINARY_INTEGER);

exec dbms_xstream_gg_internal.set_gg_sess_flags_int(1,1);

          
      *

      ERROR at line 1:

      ORA-26947: Oracle GoldenGate replication is not enabled.

SET_SESSION_ACTION

Undocumented dbms_xstream_gg_internal.set_session_action( 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_LOG_FILE_INT (new 23ai)

Undocumented dbms_xstream_gg_internal.switch_log_file_int;

TBD

UNSET_SESSION_ACTION

Undocumented dbms_xstream_gg_internal.unset_session_action( action_name IN VARCHAR2, logmnr_session# IN NUMBER, force IN BOOLEAN);

TBD

UPDATE_ERROR_TXN

Undocumented dbms_xstream_gg_internal.update_error_txn( transaction_id IN VARCHAR2, error_flags IN NUMBER);

TBD