Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: rollback segments during export

Re: rollback segments during export

From: Jared Still <>
Date: Sun, 30 Sep 2001 20:30:14 -0700
Message-ID: <>

Without proof though, there are other explanations.

Like no DML was taking place while you ran the export.

The way to test it is check while running an export.

I don't know how to do that off the top of my head.


On Sunday 30 September 2001 18:05, Reardon, Bruce (CALBBAY) wrote:
> We use export / import to refresh our test system.
> We do the exports from OEM with consistent=y (this is on NT, version 8.1.5
> and 8.1.7).
> We have lots of tables with foreign key constraints and have not had any
> problems with the constraints being reenabled in test.
> That is, consistent=y seems to me to prevent the tables getting out of
> sync.
> At one stage, I ran into an OEM bug (1429380 / 1080622) related to the
> copying of OEM advanced export job settings - this lead to doing a
> consistent=N export and then when we imported into our test system some of
> the constraints could not be enabled.
> This adds weight to consistent=y keeping tables in sync across the entire
> database.
> HTH,
> Bruce Reardon
> -----Original Message-----
> Sent: Sunday, 30 September 2001 5:40
> Chris,
> > Just because there is a PK/FK between tables, it does not mean they will
> be
> > exported in the same transaction. And thus, possibly out of sync.
> I didn't say there was. My implication was that your
> tables would get out of sync. Setting 'consistent=y'
> won't prevent that:
> : If you specify CONSISTENT=N (the default), each table is usually exported
> : in a single transaction. However, if a table contains nested tables, th
> Now it *could* be that I'm misreading the docs. It' been known
> to happen, but that sentence says to me that each table is
> exported as part of a single transaction.
> Anyone have proof to the contrary? The tech writer is being
> rather ambigous, at least I think so.
> Jared

Please see the official ORACLE-L FAQ:
Author: Jared Still

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Sep 30 2001 - 22:30:14 CDT

Original text of this message