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 LazyDBA home page