impdp error

[karthikmca.bhc]

Hi Erman

Getting below error when importing schema.

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** dumpfile=EB_%U.DMP directory=DATA_PUMP_DIR logfile=impdp_20parelel_EB.log schemas=EB parallel=20 include=statistics

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."APT_COMP_NUQ_IDX" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."APT_FK_SALES_ALLOC_PROC_UID" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:1

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."APT_KEY_IDX" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,N

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."APT_PK_PRIM" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,N

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."APT_RC_IDX" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,NU

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."ACCGRP_PK_PRIM" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:1

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."ACCGRPDET_PK_PRIM" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-20000: INDEX "EB"."EB_APTP_UK" does not exist or insufficient privileges

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES



Please advise.

[ErmanArslansOracleBlog]

Hi,

Please answer the following questions;

1)Those indexes are created by import successfully right? (review impdp log file for this)
2)What kind of indexes are they? (send me the script of one of them)
3)What are your OS and RDBMS version?
4)Any errors in export (expdp) log file
5)Any errors in Alert log file of the source and target databases (during expdp and impdp run)?
6)There are some bugs in 11.2.0.3 about these things.
 -- You have 2 workarounds - >
       You can yse the EXCLUDE_INDEX_STATS parameter during import with datapump in 11.2.0.3.
       You can Gather the index statistics after the import has finished for the necessary indexes.

[karthikmca.bhc]

Hi Erman,

I did a mistake in import as i didnt include the statistics in my impdp command.

I did a export of schema from source with include=statistics,index and while import i didnt include the parameter "include=statistics" and i encountered the errors.

As per oracle note "ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)"

Thanks for your advise and that's useful.

I am exporting schema from 12.1.3 ebs database and importing into 12.2.5 ebs database(12.1.0.2). Is this affect any of our customization tasks? because 12.1.3 doesnt hold editioning feature where as 12.2.5 has. What developers must follow while they do customization in this case of migration?

Thanks.

[ErmanArslansOracleBlog]

Go to Oracle support->
open this note -> R11i / R12 : Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12 (Doc ID 1406960.1)
There in the bottom of the page you will find a whitepaper.
Take a look at that -> Planning Your Oracle E-Business Suite Upgrade from Release 11i to Release 12
Read customization related parts especially.

[karthikmca.bhc]

Thanks Erman.. It was very useful.