3 Replies Latest reply on Oct 3, 2013 5:33 PM by user481739

    DataPump - Validate Export vs Import Record Count




      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.