3 Replies Latest reply: Jan 30, 2013 1:45 PM by Dean Gagne-Oracle RSS

    expdp missing data - constraints fail

    Merlin128
      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?