From jkstill@cybcon.com Mon, 01 Oct 2001 08:54:35 -0700 From: Jared Still Date: Mon, 01 Oct 2001 08:54:35 -0700 Subject: Re: rollback segments during export Message-ID: MIME-Version: 1.0 Content-Type: text/plain John, You're making perfect sense, as that is the way I've always thought it worked. Based on some previous threads I read ( don't know if it was this list ) and ambiguous language in the docs, I'm not sure if it actually works that way. Jared On Monday 01 October 2001 00:50, John Kanagaraj wrote: > Jared et al, > > My understanding could be flawed, but I think that setting 'CONSISTENT=Y' > just adds a 'SET TRANSACTION READ ONLY' to the entire export process and > thus ensures that all subsequent queries read all tables as of the time the > export started. Keep in mind that an export just does a 'select * from > along with a lot of other DDL generation. > This is the reason you can expect ORA-01555 errors when trying to read from > a wrapped-around or shrunk rollback segment in the case a read-consistent > read is required.... > > I hope I am making sense here.... > > John Kanagaraj > Oracle Applications DBA > DB Soft Inc > Work : (408) 970 7002 > > Listen to great, commercial-free christian music 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message are entirely mine > and do not reflect those of my employer or customers ** > > >-----Original Message----- > > From: Jared Still [mailto:jkstill@cybcon.com] > > >Sent: Sunday, September 30, 2001 12:40 AM > >To: Multiple recipients of list ORACLE-L > >Subject: Re: rollback segments during export > > > > > > > >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@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: jkstill@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@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).