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 - 06:55:19 CDT