Uli wrote:
> 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
At least you need fromuser=miller touser=miller appended to your
import command line.
And... you DO realize what the destroy=y option is all about, do you?
Try imp -help for a change, or reading the manual - there all online
at tahiti.oracle.com (or docs.oracle.com, or otn.oracle.com)
--
Regards,
Frank van Bortel
Received on Fri Jun 11 2004 - 06:16:14 CDT
