This discussion is archived
3 Replies Latest reply: Jan 30, 2013 11:45 AM by Dean Gagne RSS

expdp missing data - constraints fail

Merlin128 Newbie
Currently Being Moderated
I have a database that needs to be up 24/7.. I run this nightly on the windows server:
 expdp user/pass DIRECTORY=Export DUMPFILE=SID.DMP LOGFILE=SID.LOG FULL=Y PARALLEL=8  
while importing the dump file into another database.. I have found that constraints fail on some tables because the parent record doesnt exist..

select * from child_table where ID not in (select ID from parent_table); shows the records..
the bad records are different each day..

its obvious that edits to these tables are being made during the export..
is there a better solution for this than shutting down the database during the export?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points