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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: unique constraint violation on 8i import but not on 9i

Re: unique constraint violation on 8i import but not on 9i

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 4 Jul 2007 20:25:45 -0400
Message-ID: <49d668000707041725y714c659j5795abcaeeb574dc@mail.gmail.com>


>The export taken from an 8i database fails on import into the same (newly
>rebuilt 8i database) with primary key violation.

Do the import with the ignore=y option then.

As Alex already said - PK is enabled AFTER table data is loaded.

After you load everything up you will end up without that violated PK and some related FK's.

Do the "select col1, col2 from that_nasty_table group by having count(*) > 1" and see what is causing duplicates. Maybe this will give some clue.

HTH

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 04 2007 - 19:25:45 CDT

Original text of this message

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