Hi all,
my job got aborted and the log view is given below,
.Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed.
SQLSTATE=S1000, DBMS.CODE=1555
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
please give suggestions on how to resolve this issue.
thanks in advance
snapshot too old
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: snapshot too old
Contact your Oracle DBA and have them increase the rollback segment for your database and or seek their advice if they want other.pxraja wrote:Hi all,
my job got aborted and the log view is given below,
.Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed.
SQLSTATE=S1000, DBMS.CODE=1555
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
please give suggestions on how to resolve this issue.
thanks in advance