Re: Data Pump Export: How to get a "consistent" export without FLASHBACK_SCN or FLASHBACK_TIME.

On Nov 20, 6:11 am, bfoga..._at_gaports.com wrote:
> Our databases were upgraded from 8i to 10gR2 not long ago. We are not
> using the "flashback database" feature on any of them. My
> understanding of flashback leads me to believe that we do not have
> enough diskspace for that at this time.
>
> I want to create an export file using the data pump export utility
> instead of the old export utility. I read that export parameter
> "consistent=y" has been replaced in data pump export by flashback_scn
> or flashback_time.
>
> Since we do not use flashback database are these two "flashback"
> parameters unavailable to me?
>
> In data pump export, if I do not specify either "flashback" parameter
> will I automatically get a consistent export?
>
> Thank you,
> Bill

> Since we do not use flashback database are these two "flashback"
> parameters unavailable to me?

flashback of data pump is 'flashback query' which totally depends on undo retention. 'flashback database' relies on flashback log and archive log to roll the whole database back to a past time, it will physically change the datafiles. 'flashback query' is only a consistent read stick to a past SCN or time. So the answer is YES, we can use the two flashback parameters.

> In data pump export, if I do not specify either "flashback" parameter
> will I automatically get a consistent export?
if no flashback parameter, the same table will be consistent, but different tables aren't, just like a few selects started at different time.

Thanks,
Jinwen Received on Wed Nov 21 2007 - 21:23:13 CST