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
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
What's New In 12cR1
What's New In 12cR2

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