Thanks for all the replies. One other option I recevied from the list was
to DROP user CASCADE then recreate the user with the necessary authorities.
Then my import worked like a charm.

Thanks for help.

Mae Bruce
State of Missouri
OA/Division of Information Services



-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.[Email Address Removed] Friday, August 31, 2001 9:30 AM
To: LazyDBA.com Discussion
Subject: RE: IMPORT Question / NT / 8.0.5


Import does NOT delete/update any data. It only INSERTS. You have to
truncate/delete before importing.

Rick

-----Original Message-----
From: Bruce, Mae [mailto:[Email Address Removed] Friday, August 31, 2001 10:19 AM
To: LazyDBA.com Discussion
Subject: 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 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