Newbie: trying to import and replace Data from Dump

Dear group,

i'm relatively new to Oracle DBA-tasks. I have the following task to do:

1. export all Data from a user to a dump
2. user is testing his upgrade skript
3. if this skript fails, data will be reloaded from dump, so that user can try again.

I exported data with something like exp system/xxx_at_db file=E:\file.dmp Owner = MILLER feedback=2000 log=E:\log

this worked fine

But while doing an import from this dump using

imp system/xxx_at_db file=E:\file.dmp full=y destroy=y feedback=2000 log = E:\implog.log

i got tons of Constraint-violations.

Is there a possibility to import and replace data using the imp-Tool or the sqlldr ?

Or do i have to delete from the tables or even drop them ?

Your help is very appreciated, please respond to the group.

Thank you

Uli Received on Fri Jun 11 2004 - 06:04:01 CDT