My Oracle Support Banner

Errors ORA-39083 ORA-20001 On TABLE_STATISTICS During Schema Import With Data Pump (Doc ID 1410703.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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,


To view full details, sign in with your My Oracle Support account.

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

In this Document

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