Data Pump Export: How to get a "consistent" export without FLASHBACK_SCN or FLASHBACK

Home -> Community -> Usenet -> c.d.o.server -> Data Pump Export: How to get a "consistent" export without FLASHBACK_SCN or FLASHBACK_TIME.

From: <bfogarty_at_gaports.com>
Date: Mon, 19 Nov 2007 14:11:21 -0800 (PST)
Message-ID: <cf1a8ee0-efb7-4ef5-8d2a-42674a95fec7@c30g2000hsa.googlegroups.com>

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 Received on Mon Nov 19 2007 - 16:11:21 CST