Oracle 12c DBMS_CDC_IMPDPV Demos

Oracle DBMS_CDC_IMPDPV Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

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

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