Re: unique constraint violation on 8i import but not on 9i
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Wed, 4 Jul 2007 20:25:45 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
