ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
XStreams support for GoldenGate
AUTHID
DEFINER
Dependencies
APPLY$_CDR_INFO
DBMS_LOGREP_UTIL
DBMS_XSTREAM_GG
APPLY$_ERROR
DBMS_STANDARD
DBMS_XSTREAM_GG_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_XSTREAM_UTL_IVK
DBMS_LOGMNR_INTERNAL
DBMS_UTILITY
V$PDBS
DBMS_LOGREP_LIB
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
Direct access to some objects in this package is prevented by means of an Accessible By clause.
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> 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
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
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;
/
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 299
ORA-06512: at line 2
dbms_xstream_gg_internal.set_foo_trigger_contxt_int(fire IN BOOLEAN);
exec dbms_xstream_gg_internal.set_foo_trigger_contxt_int(FALSE);
BEGIN
dbms_xstream_gg_internal.set_foo_trigger_contxt_int(FALSE); END;
*
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 line 1
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
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);
