RE: Snapshot too old

Yeah - on export - with CONSISTENT=N !! I don't know why this is happening except that the insert process to the big table is causing it to wait.

Thanks for your response though.

..tom

> -----Original Message-----
> From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> Sent: Friday, July 14, 2000 7:55 AM
> To: ORACLE-L_at_fatcity.com; blair_at_pjm.com
> Subject: RE: Snapshot too old
>
> Are you sure you get this on export and not IMPORT. If it is import then
> you can use the
> COMMIT=Y option
>
> Rick
>
>
> > -----Original Message-----
> > From: blair_at_pjm.com [SMTP:blair_at_pjm.com]
> > Sent: Friday, July 14, 2000 8:21 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Snapshot too old
> >
> > We are having trouble exporting a database with several large,
> > insert-active
> > tables. Exporting these tables causes a 1555 "Snapshot too old" error.
> > The
> > error message says use larger rollback segments. I doubled the size of
> > our
> > rollback segs but I don't want to make them all bigger just for one
> > occasional
> > export.
> >
> > Is there a way to create a and use a very large rollback segment just for
> > the
> > export? How would you approach solving this problem - this is a
> > production
> > database and taking it off-line is probably not possible.
> >
> > tia,
> >
> > ..tom
> >
> >
> >
> >
> > --
> > Author:
> > INET: blair_at_pjm.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_at_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).
Received on Fri Jul 14 2000 - 07:10:56 CDT