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

All

 

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.

Legend

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