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 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

Related Topics
DBMS_CDC_EXPVDP
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_CDC_UTILITY
Packages

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-2014 Daniel A. Morgan All Rights Reserved