export problem - snapshot too old

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1997/11/07
Message-ID: <34632B63.2E317411@mindspring.com>#1/1

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