Skip to Main Content
Forums

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!

CONSISTENT and FLASHBACK_TIME parameters in export

Pete_Sg1Oct 25 2012 — edited Oct 25 2012
Version: 11.2

This is what I gather about CONSISTENT (Original exp) and its datapump equivalent FLASHBACK_TIME


If i give CONSISTENT=Y (for exp) or FLASHBACK_TIME=SYSTIMESTAMP (for expdp datapump) and start an export job at 3PM , oracle will export all tables (and all other objects ) as of 3PM. Any changes to schema objects done after 3PM will be ignored. I think Oracle internally uses UNDO tablespace for this feature.


From your experience, what are the consequences you had by not setting CONSISTENT=Y (for exp) or FLASHBACK_TIME=SYSTIMESTAMP (for expdp datapump) ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2012
Added on Oct 25 2012
#database-key-features, #export-import-sql-loader-external-tables
3 comments
1,994 views