Keeping consistent.....

Want to make sure the data is consisent when you use datapump, missing consistent=y from the old exp utility?

Well for 10 and 11 you can easily use

Flashback_time=systimestamp (no messing about with date formats/quotes etc)

Or if you have 11.2……

You can now even say consistent=y – it does a conversion for you J

Legacy Mode Parameter: "consistent=TRUE" Location: Command Line, Replaced with: "flashback_time=TO_TIMESTAMP('2012-08-16 10:22:02', 'YYYY-MM-DD HH24:MI:SS')"


0 comments:

Post a Comment