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!

Current Fashback Time in 10g DataPump Export

Jim ThompsonApr 13 2012 — edited Feb 20 2013

Does anyone know how to specify the current date and time for FLASHBACK_TIME in a 10gR2 expdp ?

11gR2 Data Pump helpfully provides the systimestamp setting so you can specify
FLASHBACK_TIME=systimestamp

However 10gR2 Data Pump does not have this option. I could use the SCN or explicitly specify a date & time but I was just wondering is there a way to easily define the current date / time in 10gR2 expdp

thanks,
Jim

This post has been answered by Dean Gagne-Oracle on Apr 13 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2013

Added on Apr 13 2012

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

4 comments

2,448 views