imp errors
YEFeb 28 2010 — edited Mar 1 2010I have a ***.dmp file. I can imp it in Oracle 11g installed at Windows server 2003 sp2 without error.
I install oracle 11g on Windows server 2008 but this file cannot be imported.
I do the following steps:
create user maintenance identified by maintenance;
grant dba, connect, resource to maintenance;
imp
Then, I get lots of errors in Oracle 11g installed on Windows Server 2008.
======================================================
"GROUPNAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREE"
"LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_RESGROUPNAME_AUTH_RES"',NUL"
"L,NULL,NULL,26,1,26,1,1,16,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_RESGROUPNAME_AUTH_RES" does not exist or
insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "AUTH_RESGROUP" ADD CONSTRAINT "AK_KEY_RESGROUPNAME_AUTH_RES" "
"UNIQUE ("RESGROUPNAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
"PACE "USERS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_RESGROUPNAME_AUTH_RES) - duplicat
e keys found
. . importing table "DATA_FIELD" 0 rows imported
. . importing table "DATA_FILTER" 0 rows imported
. . importing table "DATA_TABLE" 0 rows imported
. . importing table "DATA_TABLEGROUP" 0 rows imported
. . importing table "DATA_TABLEREF" 0 rows imported
. . importing table "DATA_VIEW" 1 rows imported
. . importing table "DATA_VIEWDATASET" 0 rows imported
. . importing table "DATA_VIEWDATASETLINK" 0 rows imported
. . importing table "DATA_VIEWFIELD" 266 rows imported
. . importing table "DATA_VIEWGROUP" 1 rows imported
. . importing table "DATA_VIEWLINK" 0 rows imported
. . importing table "DATA_VIEWVARIL" 0 rows imported
. . importing table "DIRECTORYDEF" 25 rows imported
. . importing table "DOCUMENTINFO" 757 rows imported
. . importing table "FORM_FORMDEF" 196 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_FORMCODE_FORM_FOR" ON "FORM_FORMDEF" ("FORMCODE"
"" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_FORMCODE_FORM_FOR"',NULL,NU"
"LL,NULL,191,1,191,1,1,72,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_FORMCODE_FORM_FOR" does not exist or insu
fficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "FORM_FORMDEF" ADD CONSTRAINT "AK_KEY_FORMCODE_FORM_FOR" UNIQU"
"E ("FORMCODE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITI"
"AL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USE"
"RS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_FORMCODE_FORM_FOR) - duplicate ke
ys found
. . importing table "FORM_FORMGROUP" 12 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_3_FORM_FOR" ON "FORM_FORMGROUP" ("FORMGROUPNAME"
"" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_3_FORM_FOR"',NULL,NULL,NULL"
",10,1,10,1,1,2,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_3_FORM_FOR" does not exist or insufficien
t privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_FORMGROUPCODE_FORM_FOR" ON "FORM_FORMGROUP" ("F"
"ORMGROUPCODE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGIN"
"G"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_FORMGROUPCODE_FORM_FOR"',NU"
"LL,NULL,NULL,10,1,10,1,1,2,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_FORMGROUPCODE_FORM_FOR" does not exist or
insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "FORM_FORMGROUP" ADD CONSTRAINT "AK_KEY_3_FORM_FOR" UNIQUE ("F"
"ORMGROUPNAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITI"
"AL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USE"
"RS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_3_FORM_FOR) - duplicate keys foun
d
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "FORM_FORMGROUP" ADD CONSTRAINT "AK_KEY_FORMGROUPCODE_FORM_FOR"
"" UNIQUE ("FORMGROUPCODE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 S"
"TORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TAB"
"LESPACE "USERS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_FORMGROUPCODE_FORM_FOR) - duplica
te keys found
. . importing table "GIS_MAPTHEME" 0 rows imported
. . importing table "JYZXPBZJ" 0 rows imported
. . importing table "OP_COMMWORDS" 0 rows imported
. . importing table "OP_COMMWORDSGROUP" 0 rows imported
. . importing table "OP_DOC" 289 rows imported
. . importing table "OP_OPTYPE" 14 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_OPTYPENAME_OP_OPTYP" ON "OP_OPTYPE" ("OPTYPENAM"
"E" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 "
"FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_OPTYPENAME_OP_OPTYP"',NULL,"
"NULL,NULL,14,1,14,1,1,1,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_OPTYPENAME_OP_OPTYP" does not exist or in
sufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "OP_OPTYPE" ADD CONSTRAINT "AK_KEY_OPTYPENAME_OP_OPTYP" UNIQUE"
" ("OPTYPENAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT"
"IAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "US"
"ERS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_OPTYPENAME_OP_OPTYP) - duplicate
keys found
. . importing table "OP_OPTYPEGROUP" 5 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_OPTYPEGROUPNAM_OP_OPTYP" ON "OP_OPTYPEGROUP" (""
"OPTYPEGROUPNAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 6553"
"6 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOG"
"GING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_OPTYPEGROUPNAM_OP_OPTYP"',N"
"ULL,NULL,NULL,5,1,5,1,1,1,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_OPTYPEGROUPNAM_OP_OPTYP" does not exist o
r insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "OP_OPTYPEGROUP" ADD CONSTRAINT "AK_KEY_OPTYPEGROUPNAM_OP_OPTY"
"P" UNIQUE ("OPTYPEGROUPNAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 25"
"5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
"TABLESPACE "USERS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_OPTYPEGROUPNAM_OP_OPTYP) - duplic
ate keys found
. . importing table "ORG_ORG" 25 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_3_ORG_ORG" ON "ORG_ORG" ("ORGNAME" ) PCTFREE 1"
"0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS"
" 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_3_ORG_ORG"',NULL,NULL,NULL,"
"27,1,27,1,1,2,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_3_ORG_ORG" does not exist or insufficient
privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "ORG_ORG" ADD CONSTRAINT "AK_KEY_3_ORG_ORG" UNIQUE ("ORGNAME")"
" USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING EN"
"ABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_3_ORG_ORG) - duplicate keys found
. . importing table "ORG_PERSON" 185 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_2_ORG_PERS" ON "ORG_PERSON" ("LOGINNAME" ) PCT"
"FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST "
"GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_2_ORG_PERS"',NULL,NULL,NULL"
",185,1,185,1,1,122,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_2_ORG_PERS" does not exist or insufficien
t privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_3_ORG_PERS" ON "ORG_PERSON" ("PERSONNAME" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_3_ORG_PERS"',NULL,NULL,NULL"
",185,1,185,1,1,122,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_3_ORG_PERS" does not exist or insufficien
t privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "ORG_PERSON" ADD CONSTRAINT "AK_KEY_2_ORG_PERS" UNIQUE ("LOGIN"
"NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGG"
"ING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_2_ORG_PERS) - duplicate keys foun
d
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "ORG_PERSON" ADD CONSTRAINT "AK_KEY_3_ORG_PERS" UNIQUE ("PERSO"
"NNAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 6553"
"6 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOG"
"GING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_3_ORG_PERS) - duplicate keys foun
d
. . importing table "PERSON_MATADATA" 29 rows imported
. . importing table "PROC_ACTIVITYDESC" 28 rows imported
. . importing table "PROC_ACTVDEF" 540 rows imported
. . importing table "PROC_ACTVDEFRELCTRL" 7233 rows imported
. . importing table "PROC_ACTVDEFRELFIELD" 0 rows imported
. . importing table "PROC_ACTVDEFRELFIGRLAYER" 0 rows imported
. . importing table "PROC_ACTVDEFRELFORM" 7268 rows imported
. . importing table "PROC_ACTVDEFRELPRIV" 0 rows imported
. . importing table "PROC_ACTVFORM" 10 rows imported
. . importing table "PROC_ACTVFORMCOLUMN" 0 rows imported
. . importing table "PROC_ACTVLINK" 493 rows imported
. . importing table "PROC_ACTVPRIV" 0 rows imported
. . importing table "PROC_BUSINESSTYPE" 7 rows imported
. . importing table "PROC_DEFINITION" 78 rows imported
. . importing table "PROC_DEFINITIONRELFORM" 779 rows imported
. . importing table "PROC_DEPUTE" 2 rows imported
. . importing table "PROC_FORMCTRLINFO" 1763 rows imported
. . importing table "PROC_FORMDEFRELVIEWFIELD" 239 rows imported
. . importing table "PROC_HANDLEDINSTANCES" 15212 rows imported
. . importing table "PROC_IDIOM" 119 rows imported
. . importing table "PROC_INSTANCECURRENTSTATE" 2655 rows imported
. . importing table "PROC_INSTHISTORY" 20678 rows imported
. . importing table "PROC_PRIV" 0 rows imported
. . importing table "PROC_ROLE" 84 rows imported
. . importing table "PROC_ROLEGROUP" 1 rows imported
. . importing table "PROC_ROLERELPRIV" 0 rows imported
. . importing table "PROC_USERRELROLE" 490 rows imported
. . importing table "PS_TXN" 647 rows imported
. . importing table "STAT_REPORTINFO" 35 rows imported
. . importing table "STAT_REPORTPARAM" 0 rows imported
. . importing table "SYS_CHINPINYIN" 0 rows imported
. . importing table "SYS_CODEINFO" 1943 rows imported
. . importing table "SYS_CODETYPE" 56 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AK_KEY_CODETYPENAME_SYS_CODE" ON "SYS_CODETYPE" ("CODE"
"TYPENAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"AK_KEY_CODETYPENAME_SYS_CODE"',NUL"
"L,NULL,NULL,56,1,56,1,1,11,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "MAINTENANCE"."AK_KEY_CODETYPENAME_SYS_CODE" does not exist or
insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2628
ORA-06512: at "SYS.DBMS_STATS", line 6963
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "SYS_CODETYPE" ADD CONSTRAINT "AK_KEY_CODETYPENAME_SYS_CODE" U"
"NIQUE ("CODETYPENAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORA"
"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESP"
"ACE "USERS" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (MAINTENANCE.AK_KEY_CODETYPENAME_SYS_CODE) - duplicat
e keys found
. . importing table "SYS_DAY" 0 rows imported
. . importing table "SYS_HOLIDAY" 22 rows imported
. . importing table "SYS_HOLIDAYSHIFT" 8 rows imported
. . importing table "SYS_SYSINFO" 1 rows imported
. . importing table "SYS_WORKDAYRULE" 1 rows imported
. . importing table "TMP_CURR_USR" 59 rows imported
. . importing table "T_MTRTEMPLET" 67 rows imported
. . importing table "T_STARTMTR" 1077 rows imported
About to enable constraints...
Import terminated successfully with warnings.
D:\app11g\Administrator\product\11.1.0\db_1\BIN>