Easy question, easy answer.....
Either you have to drop the objects before importing them... or you have to
truncate
teh tables and import the data ignoring the creation errors.
Exporting something doesn't mean deleting it... and importing something
doesn't
imply fludhing the data on the tables involved.


> -----Mensaje original-----
> De: Bruce, Mae [mailto:[Email Address Removed] Enviado el: ostirala, 2001.eko abuztuak 31 16:19
> Para: LazyDBA.com Discussion
> Asunto: IMPORT Question / NT / 8.0.5
>
>
> I ran an export yesterday on my training database. Today I
> want to import
> that file back into the same database. I get the ORA-0001
> message saying
> that the unique constraint is violated. It appears to me that
> it is not
> getting rid of the data that was previously there before
> trying to insert.
> Can someone shed some light on what I am overlooking?
>
> My export looked like this:
> c:\orant\bin\exp80 user/[Email Address Removed] full=y consistent=y buffer=640000
> file=w:\budget\trn1\export\exp082901.dmp
> log=w:\budget\trn1\export\exp.log
>
> My import looks like this:
> c:\orant\bin\imp80 user/[Email Address Removed] buffer=640000
> file=w:\budget\trn1\export\exp082901.dmp
> log=w:\budget\trn1\export\imp.log
> fromuser=bti touser=bti ignore=yes destroy=yes
>
> (Sorry to bother you all with such a trival thing here, but I
> looked in
> books and help files and I can't come up with anything
> different to try.)
>
> Thanks for your help.
>
> Mae Bruce
> State of Missouri
> OA/Division of Information Services
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page