Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exp/imp unable to create unix index

exp/imp unable to create unix index

From: mitchell <mitchell_at_comnet.ca>
Date: Mon, 10 Dec 2001 10:13:13 -0800
Message-ID: <F001.003D9064.20011210094025@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US