Oracle DBMS_XSTREAM_GG
Version 19c

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 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 role
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
DISABLE_TDUP_WORKSPACE IS_CHARSET_COMP_FOR_MINING SET_GG_NO_WS_FOR_DEF_CONS
ENABLE_TDUP_WORKSPACE IS_CTAS_NO_DML_AT_SESSION SET_GG_SESSION
GET_GG_NO_STMT_BUF IS_FOO_TRIGGER_FIRE_AT_SESSION SET_GG_SESSION_FLAGS
GET_GG_NO_WS_FOR_DEF_CONS IS_TDUP_WORKSPACE_ENABLED SET_GG_XML_SCHEMA
GET_GG_SESSION SET_CTAS_SESSION_CONTEXT SET_SESSION_ACTION_GG
GET_GG_SESSION_FLAGS SET_FOO_TRIGGER_SESSION_CONTXT UNSET_SESSION_ACTION_GG
GET_GG_XML_SCHEMA SET_GG_NO_STMT_BUF  
 
DISABLE_TDUP_WORKSPACE
Undocumented

Generates an error if not executed by the correct internal program		 dbms_xstream_gg.disable_tdup_workspace;
exec dbms_xstream_gg.disable_tdup_workspace;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 308
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 85
ORA-06512: at line 1
 
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;
*
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 "SYS.DBMS_XSTREAM_GG", line 54
ORA-06512: at line 1
 
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
FROM dual;

GET_GG_SESSION_FLAGS
--------------------
                   0
 
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;
SQL> SELECT dbms_xstream_gg.is_charset_comp_for_mining('AL32UTF8')
2 FROM dual;

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;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 348
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 274
ORA-06512: at line 2
 
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;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 264
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 28
ORA-06512: at line 2
 
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;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 299
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 70
ORA-06512: at line 2
 
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);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 339
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 259
ORA-06512: at line 1
 
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);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 255
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 13
ORA-06512: at line 1
 
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);
*
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 "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 162
ORA-06512: at line 1
 
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);
*
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 "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 232
ORA-06512: at line 1
 
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);
*
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 "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 135
ORA-06512: at line 1
 
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);
*
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 "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at line 1
 
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);
*
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 "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 197
ORA-06512: at line 1
 
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
 
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 19c
What's New In 20c-21c

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