This discussion is archived
3 Replies Latest reply: Oct 3, 2013 10:33 AM by user481739 RSS

DataPump - Validate Export vs Import Record Count

user481739 Newbie
Currently Being Moderated



Wondering is there any technique to validate RECORD COUNTS between Data Pump Export vs Import, when using only DATA_ONLY export option.


1) Exporting  DATA_ONLY using Data Pump.(No DB objects or Metadata)

2) Importing DATA_ONLY using Data Pump.


Post Import, want to compare No of Records migrated on each table are match between Export vs Import.


Debating with following 2 options.


1) should I compare using LOG files between Export vs Import( more unix format and compare files)

2) Generate SELECT COUNT(*) FROM .... sql using EXPORT and IMPORT log file, then compare those results.


Please share if anyone done anything similar. Appreciate your input.


Thanks in advance.


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