Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: export problem - snapshot too old
As your message says Rollback Segment too small. Increase the rollback segment.
Patrick Tan wrote:
> Environment
> Oracle 7.1.6
> HPUX 10.01
>
> My nightly database export encounter the following problem recently.
> This does not happen every night but averaging once in 5 nights.
>
> .exporting table ................
> .exporting table CF_COMMIT 184019 rows exported
> EXP-00008: ORACLE error 1555 encountered
> ORA-01555: snapshot too old (rollback segment too small)
> EXP-00222:
> System error message 2
> EXP-00000: Export terminated unsuccessfully
>
> It failed at different tables and there is no insert, update and
> delete
> activities on the database when I perform the database export. Please
> help. I am using unix pipe to export the database directly to gzip
> format.
>
> Patrick
Received on Fri Nov 07 1997 - 00:00:00 CST