RE: rollback segments during export

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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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).