Errors ORA-39083 ORA-20001 On TABLE_STATISTICS During Schema Import With Data Pump

(Doc ID 1410703.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2013***


You are performing a schema import with data pump (impdp) and the following errors are raised while importing the tables statistics:

ORA-39083: object type TABLE_STATISTICS created failed, error occurs:
ORA-20001: Invalid or inconsistent input values
The failed sql is: DECLARE c varchar2(60); nv varchar2(1); df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; s varchar2(60) := '<schema>'; t varchar2(60) := '<table>'; p varchar2(60) := '<table partition>'; 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,flags,cl1) VALUES (:1,6,:2,:3,:4,:5,:6,


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