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 is now availble. If you haven't you downloaded already: Why?

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