Re: rollback segments during export

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.

Jared

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: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).