import and constraints

[hrishy]

Hi

After a long time today i did a import and after running the import i see that the log file had a message saying unable to enable constraint because of duplicate keys.

I see that the database has duplicate rows in the table.I dont have aceses to the source database

My question is if the source database has duplicate rows and the constraints are disabled does import tries to enable the constraint ?

If the source database had the constraint has initially deffered an no validate and then reenabled the constraints does import fail while enabling the constraints ?

regards
Hrishy

[PAVB]

I've seen that.

Here is what I would do.

1- Import with CONSTRAINTS=NO option so imp wouldn't try to create constraints.
2- Create constraints with NOVALIDATE, ENABLE options.

If you do not have access to source database you can still get basic DDL for constraints running import with SHOW=YES, ROWS=NO options.