Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> exp/imp unable to create unix index
Hi gurus
I had oracle1452 when imp/exp database from test to prod databases.
I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database
exporting table PA_PROJECTS_ALL 3160 rows exported importing table "PA_PROJECTS_ALL" 3160 rows imported exporting table PO_VENDORS 57688 rows exported importing table "PO_VENDORS" 57688 rows imported
Why, any idea?
Mitchell
This is the log from imp.
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "PA_PROJECTS_U3" ON "PA_PROJECTS_ALL" ("NAME" )
PCTFRE"
"E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS
"
"1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL
D"
"EFAULT) TABLESPACE "PAX" NOLOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "PO_VENDORS_U2" ON "PO_VENDORS" ("VENDOR_NAME" )
PCTFR"
"EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144
MINEXTENT"
"S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1
BUFFER_POOL"
" DEFAULT) TABLESPACE "POX" NOLOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: mitchell_at_comnet.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Dec 10 2001 - 12:13:13 CST
![]() |
![]() |