3 Replies Latest reply: Oct 3, 2013 12:33 PM by user481739 RSS

    DataPump - Validate Export vs Import Record Count

    user481739

      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.