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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
