Steve, You may have to dig a little further... What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be? This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments.
If no table data was modified after export started reading that table, then there is no need to read RBS info (except for the DBC case, IMO). - Kirti --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Oh yeah, for the export consistent=N > > -----Original Message----- > Sent: Thursday, May 29, 2003 9:14 AM > To: '[EMAIL PROTECTED]' > > > A certain alignment of the planets occurred creating a good ole ORA-01555 error... A > user level > export received the snapshot too old error and terminated. Concurrent to this was an > RMAN backup > and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being > backed up > via the user level export. There was no other end user access to the schema data. > Since exp got > the error I assume it was reading from the rollback segments but why? I'm suspecting > dbms_stats. > We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN > which could > create this problem? > > (Of course we need to improve our job scheduling but that's another issue, the > timing of the > user level export is application driven and out of our control). > > > Befuddled in Bozeman, > Walt and Steve > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
