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