Forum Stats

  • 3,826,865 Users
  • 2,260,714 Discussions
  • 7,897,108 Comments

Discussions

DataPump - Validate Export vs Import Record Count

user481739
user481739 Member Posts: 10

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.

Tagged:

Best Answer

  • DK2010
    DK2010 Member Posts: 1,542 Silver Trophy
    Answer ✓

    Hi,

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

    there is no need to do all the Process, Just look for Error in export/import Log file.. if You do not get any error means your counts are fine..this is enough to validate the record.

    HTH

Answers

This discussion has been closed.