Skip to main content
7-Bedrock
December 1, 2011
Question

How to Export Oracle Dump between two specific dates.

  • December 1, 2011
  • 0 replies
  • 1006 views

Hi All,

Normally we use Oracle export Command to Export oracle Dump. i.e.

exp system/manager file=E:\backups\OracleMetadata\productionplmdb.dmp owner=dbuser log=E:\backups\OracleMetadata\productionplmdb.log statistics =none

In this case we export all data from databse to .dmp file and then import it to when u required.

now i need only data within specific dates like. i want oracle dump files from 1 dec 20011 to 5 dec 2011 from the enitre databse.

Then for This Condition what will be the export Command, and how i can import this perticular data to Oracle without overriding other previous data present in database.

Thanks and Regards,

Vivek Uchekar