AW: exp/imp unable to create unix index

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Mon, 10 Dec 2001 11:04:14 -0800
Message-ID: <F001.003D9107.20011210103021@fatcity.com>

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:v.schoen_at_inplan.de
http://www.inplan.de

-----Ursprüngliche Nachricht-----

Von: mitchell [mailto:mitchell_at_comnet.ca] 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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Schoen Volker
INET: v.schoen_at_inplan.de

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