Oracle 12cR2 DBMS_CDC

Oracle DBMS_CDC_IMPDPV Version 12.2.0.1

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

BUMP_SEQUENCE

CREATE_IMPORT_VALIDATION

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