Thread: exp 0008 Ora-01555
03-30-09, 14:35 #1Banned
- Join Date
- Apr 2003
- Washington DC area
Unanswered: exp 0008 Ora-01555
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small
EXP-00000: Export terminated unsuccessfully
I have a mountain of data but I'm transaction light. ?Would it be easy to just increase the rollback segment.?
03-30-09, 15:17 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
http://asktom.oracle.com has a fine write up on ORA-01555 errors.
The long running session throws this error.
Error occurs when either when COMMIT exists within long running PL/SQL procedure
or when another session is doing DML against same table as long running query.
The fix is 1 of 2 choices, either stop doing DML to make UNDO/RBS larger.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.