cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

How to Export Oracle Dump between two specific dates.

VivekUchekar
2-Guest

How to Export Oracle Dump between two specific dates.

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

0 REPLIES 0
Announcements

Top Tags