Maybe the tables still exist in Prod and have some data inside. Try to drop tables in prod before importing.
HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -----Ursprüngliche Nachricht----- Von: mitchell [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 18:40 An: Multiple recipients of list ORACLE-L Betreff: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).