HP 11.0
Oracle 8.0.6.0.0
I have the following issue and I'm trying to determine why it occurs.
Export a schema that owns the SNAPSHOTS. i.e SNAP$_ tables.
The snapshots are refreashed and this process completes at 7am.
The OWNER export of the snapshots starts at 7:30. Using CONSISTENT=N.
But the process ends up getting
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 4 with name "R03" too small
EXP-00000: Export terminated unsuccessfully
Now, I'm trying to determine why the ROLLBACK is being used. Surely, once the SNAP$_ refresh process has finished and consistent read from the rollback segments wouldn't be needed during the export.
Any ideas,
Cheers
OCP 8i, 9i DBA
Brisbane Australia