Datapump Impdp Utility Fails with Error ORA-39083 ORA-20000 TABLE Does Not Exist or Insufficient Privileges

(Doc ID 1595080.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.
*** Checked for relevance on 02-Nov-2016 ***


-- Problem Statement:
Statistics not imported correctly when using REMAP_TABLE and/or REMAP_SCHEMA parameters

-- Steps To Reproduce:

run Data Pump Export
drop or rename the table
run Data Pump Import with REMAP_TABLE and/or REMAP_SCHEMA parameters

DataPump shows following errors :

ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-20000: TABLE "owner"."table_name" 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) := 'LYNN'; t varchar2(60) := 'IMPDP_TEST'; 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,flags,cl1) VALUES (:1,6,:2,
Job "LYNN"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 13:53:34



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