option 3 -- increase the rollback segments and redo with users in the
database
jumping in... yes of course an export will use a rollback segment.. to all
intents and purposes, exporting a table is the same as doing a select * from
<tablename> that is written to a spool file.
so it doesn't matter if you are using consistent=y or not (sorry Scott, all
that does is make sure that EVERY table that has referential integrity is
consistent within the constraints). if you are doing an export, and someone
is updating the table, the export will read from the rollback segment
Paul is right, the best way is to export with no users in the system. If you
can't do that (24x7) then change rollback segment number and sizes and pray
each time you run the export. Because you will always be at risk for the
snapshot too old.
Rachel
>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Fwd: RE: EXP-00008: ORACLE error 1555 encountered
>Date: Fri, 16 Mar 2001 14:56:49 -0800
>
>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
><export job completes>
>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: [EMAIL PROTECTED]
>Organization: Fat City Network Services, San Diego, California
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>
>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:[EMAIL PROTECTED]]
> > 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: [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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).