The first import was into an "empty" database? The second import, data
exists as well as constraints. Remember that import builds constraints
AFTER loading table data, so the first time you ran it, there weren't
any constraints to violate. If using full database export file, then
you can drop user with cascade to drop a schema with its tables, then
run import using fromuser/touser to reload that schema. Remember that
import can duplicate table data if you're not careful.

-----Original Message-----
From: Chitra
[mailto:oracledba-ezmlmshield-x77232731.[Email address protected]
Sent: Tuesday, September 05, 2006 1:25 AM
To: LazyDBA Discussion
Subject: import full database



Need urgent help,


Imported full database in new server, I want to import again database
updated , what type of export shud I take, I tried taking import of full
database, it's giving me error about constraint voilation and all
other....



Thanks,

Chitra


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page