Impdp Fails With ORA-39083 PLS-302 Component IMPORT_TABLE_STATS Must be Declared During Import TABLE_STATISTICS (Doc ID 470768.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6
This problem can occur on any platform.

Symptoms

You successfully performed a schema or table DataPump export. During DataPump import the following errors occur:

...
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 8, column 197:
PLS-00302: component 'IMPORT_TABLE_STATS' must be declared
ORA-06550: line 8, column 186:
PL/SQL: Statement ignored
Failing sql is:
BEGIN DELETE FROM "SYS"."IMPDP_STATS"; INSERT INTO "SYS"."IMPDP_STATS" (type,
version, flags,
c1, c2, c3, c5,
n1, n2, n3, n4, n10, n11, n12, d1)
VALUES ('T', 4, 0, 'TAB001', NULL, NULL, 'TEST', 1, 5, 6, 1, NULL, NULL,
NULL, TO_DATE('2007-
Job "DBA01"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at 12:07:39

Impdp is started as privileged user DBA01 (with IMP_FULL_DATABASE role granted). If you start the import as SYSTEM, then this works.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms