Oracle DBMS_XSTREAM_GG_INTERNAL
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose XStreams support for GoldenGate
AUTHID DEFINER
Data Types  
Dependencies
APPLY$_CDR_INFO DBMS_LOGREP_UTIL DBMS_XSTREAM_GG
APPLY$_ERROR DBMS_STANDARD DBMS_XSTREAM_GG_ADM
DBMS_LOGMNR_INTERNAL DBMS_STREAMS_ADM_UTL_INVOK DBMS_XSTREAM_UTL_IVK
DBMS_LOGREP_LIB DBMS_UTILITY V$PDBS
Documented No
First Available 12cR1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
 
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);
SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Database altered.

SQL> DECLARE
  2   pdbtab dbms_utility.uncl_array;
  3   oval1 NUMBER;
  4   oval2 NUMBER;
  5  BEGIN
  6    pdbtab(1) := 'CDB$ROOT';
  7
  8    dbms_xstream_gg_internal.build_pdbset_dictionary(pdbtab, 0, oval1, oval2);
  9    dbms_output.put_line(oval1);
 10    dbms_output.put_line(oval2);
 11  END;
 12  /
2459665
2459665


PL/SQL procedure successfully completed.
 
DISABLE_TDUP_WRKSPC_INT
Undocumented dbms_xstream_gg_internal.disable_tdup_wrkspc_int;
exec dbms_xstream_gg_internal.disable_tdup_wrkspc_int;
 
ENABLE_TDUP_WORKSPACE_INT
Undocumented dbms_xstream_gg_internal.enable_tdup_workspace_int;
SQL> exec dbms_xstream_gg_internal.enable_tdup_workspace_int;
BEGIN dbms_xstream_gg_internal.enable_tdup_workspace_int; END;

*
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 line 1
 
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
FROM dual;
 
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;
 
 
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;
/
 
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('What 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 dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int RETURN BOOLEAN;
exec dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int(FALSE);
 
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
 
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);
 
SET_GG_SESS_FLAGS_INT
Undocumented dbms_xstream_gg_internal.set_gg_sess_flags_int(
gg_flags IN BINARY_INTEGER,
smode    IN BINARY_INTEGER);
SQL> exec dbms_xstream_gg_internal.set_gg_sess_flags_int(1,1);
BEGIN dbms_xstream_gg_internal.set_gg_sess_flags_int(1,1); END;
*
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 line 1
 
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
 
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

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
What's New In 18cR3
What's New In 19cR2

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