General Information
Library Note
Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose
Streams Change Data Capture DataPump Import Utility
AUTHID
CURRENT_USER
Dependencies
ALL_TABLES
CHANGE_TABLES
DBMS_CDCAPI_LIB
CHANGE_SETS
DBA_SUBSCRIPTIONS
DBMS_CDC_DPUTIL
CHANGE_SOURCES
DBMS_ASSERT
DBMS_CDC_EXPDP
Documented
No
First Available
Not known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtcdpi.plb
Subprograms
BUMP_SCN
Undocumented
dbms_cdc_impdpv.bump_scn(new_scn IN NUMBER);
conn / as sysdba
SELECT current_scn
FROM v$database;
exec dbms_cdc_impdpv.bump_scn (99999);
SELECT current_scn
FROM v$database;
-- clearly it is not affecting the current system change number
BUMP_SEQUENCE
Undocumented
dbms_cdc_impdpv.bump_scn(
sequence_owner IN VARCHAR2,
sequence_name IN VARCHAR2,
new_value IN NUMBER);
conn uwclass/uwclass@pdbdev
CREATE SEQUENCE seq;
SELECT seq.NEXTVAL FROM dual;
SELECT seq.NEXTVAL FROM dual;
exec dbms_cdc_impdpv.bump_sequence ('UWCLASS', 'SEQ', 99);
SELECT seq.NEXTVAL FROM dual;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4882], [0x7FF871ADC68], [0x7FF852E0DD8], [0x7FF8FF551A8], [], [], [], [], [], [], [], []
SELECT COUNT(*)
FROM user_objects
WHERE object_name = 'SEQ';
-- here's the fascinating part copied straight out of SQL*Plus because I couldn't make this up
SQL> CREATE SEQUENCE seq;
CREATE SEQUENCE seq
*
ERROR at line 1:
ORA-00955: name is already used by an existing object -- it fails because it exists?
SQL> SELECT seq.NEXTVAL FROM dual;
NEXTVAL
----------
100
CREATE_IMPORT_VALIDATION
Undocumented
dbms_cdc_impdpv.create_import_validation(
fullvldtab IN VARCHAR2,
impvldtab IN VARCHAR2,
prepost IN BINARY_INTEGER,
schema IN VARCHAR2);
TBD