Data Pump Import Errors ORA-39083 ORA-06550 on SYS.DBMS_CDC_UTILITY.IMPORT_CHANGE_TABLE (Doc ID 2848352.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Using Data Pump to export from a 12.1.0.2 database and import into a 19c database, import completed successfully but with the following errors in the import log:

Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'SYS.DBMS_CDC_UTILITY' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored

Failing sql is:
BEGIN
 SYS.DBMS_CDC_UTILITY.IMPORT_CHANGE_TABLE(CHANGE_TABLE_TYPE=>'1',MAJOR_VERSION=>'1',MINOR_VERSION=>'0',DATABASE_NAME=>'ORAPR2D.BFTG.COM',OWNER=>'"<OWNER>"',CHANGE_TABLE_NAME=>'"<CHANGE_TABLE_NAME>"',CHANGE_SET_NAME=>'SYNC_SET',SOURCE_SCHEMA=>'"<OWNER>"',SOURCE_TABLE=>'"<TABLE_NAME>"',CREATED_SCN=>'24402046',LOWEST_SCN=>'1',HIGHEST_SCN=>'0',COLUMN_TYPE_LIST=>' "DESCRIPTION" INT,"LOADID" INT,"RDATE" INT,"RECORDCOUNT" INT,"SERVICEID" INT,"STATUS" INT',COL_CREATED=>' 24402046,24402046,24402046,24402046,24402046,24402046',CAPTURE_VALUES=>'BOTH',RS_ID=>'Y',ROW_ID=>'Y',USER_ID=>'Y',TIMESTAMP=>'Y',OBJECT_ID=>'N',SOURCE_COLMAP=>'N',TARGET_COLMAP=>'N',DDL_MARKERS=>'N',OPT_CREATED=>'24402046,24402046,24402046,24402046,0,0,0,0');
 END;

Synchronous CDC is configured in the 12c database for a single change table, confirmed by query of sys.change_tables.

NOTE:  To check CDC use in a database for export, query sys.change_sources, sys.change_sets, sys.change_tables, dba_subscribed_tables, dba_subscriptions.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.