From drake@psscorp.com Fri, 16 Mar 2001 15:02:36 -0800 From: Paul Drake Date: Fri, 16 Mar 2001 15:02:36 -0800 Subject: Fwd: RE: EXP-00008: ORACLE error 1555 encountered Message-ID: MIME-Version: 1.0 Content-Type: text/plain 2 options: 1. Option #1 - produce a real dump file - export a quiescent database shutdown immediate startup restrict call export job with user that has restricted session alter system disable restricted session; 2. Option #2 - create a garbage export. call export job without consistent=Y update resume. hth, Paul -------- Original Message -------- Date: Fri, 16 Mar 2001 12:01:02 -0800 Reply-To: ORACLE-L@fatcity.com Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L Are you doing a consistent=y export? Was there significant activity on the system? Scott Shafer San Antonio, TX "In /dev/null no one can hear you scream..." > -----Original Message----- > From: Charlie Mengler [SMTP:charliem@mwh.com] > Sent: Friday, March 16, 2001 8:42 AM > To: Multiple recipients of list ORACLE-L > Subject: EXP-00008: ORACLE error 1555 encountered > > FWIW this is a V7.3.4.5 DB on V2.6 Solaris. > For months & months I've had this nightly export script run via cron. > Last night it generated the error below. > I was unaware that export used RBS. > Other than making the RBS larger, how can I avoid this in the future. > > TIA! > > Connected to: Oracle7 Server Release 7.3.4.5.0 - Production > With the distributed and parallel query options > PL/SQL Release 2.3.4.5.0 - Production > Export done in US7ASCII character set > Note: indexes on tables will not be exported > > About to export specified tables via Direct Path ... > Current user changed to MWH > . . exporting table DBW_DAILY_SALES > > ORA-01555: snapshot too old: rollback segment number 1 with name "R05" too > small > Export terminated successfully with warnings. > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: drake@psscorp.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).