Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract an oracle 11g dump for a specific date range

user2595039Jun 26 2017 — edited Jul 4 2017

I want to extract a dump for last 2 years from oracle 11g database. I have tried using below mentioned technique

I have tried using below command

expdp system/anirban2017@XE parfile=C:\oraclexe\app\oracle\admin\XE\pfile\myfile.par

My par file is described below

dumpfile=expempdplast3d.dmp flashback_time="to_timestamp(to_char(sysdate-3,'DD-MON-YYYY'),'DD-MON-YYYY hh24:mi:ss')"

Please suggest whether it would be the correct approach to extract such dump

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2017

Added on Jun 26 2017

#database-key-features, #export-import-sql-loader-external-tables

13 comments

1,722 views