Datapump Import fails with ORA-39083 and ORA-20000 table does not exist or insufficient privileges errors. (Doc ID 1596432.1)

Last updated on NOVEMBER 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following errors were reported in the DataPump Import log:

ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-20000: TABLE "APPS"."EUL5_B130503185418Q1R151" does not exist or insufficient privileges
Failing sql is:
DECLARE   c varchar2(60);   nv varchar2(1);   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';   s varchar2(60) := 'APPS';   t varchar2(60) := 'EUL5_B130503185418Q1R151';   p varchar2(1);   sp varchar2(1);   stmt varchar2(300) := 'INSERT INTO "SYS"."IMPDP_STATS" (type,version,c1,c2,c3,c4,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,d1,r1,r2,ch1
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-20000: TABLE "APPS"."EUL5_B130503185418Q2R151" does not exist or insufficient privileges

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