ERROR: Error fetching from cursor. ORACLE error is ORA-01555:

[Kishore Kumar]

Can some one help me.

I am unable to solve this problem.

when i am executing my program with obs=1 Crore it is working fine , but for obs=max i am unable to execute.

I am getting an error like this:-

ERROR: Error fetching from cursor. ORACLE error is ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too small.

Please suggest me some thing????


Waiting for your feedback.

Regards,
Kishore.K


---------------------------------
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

[unknown]

In my experience, this occurs when you are asking Oracle to do too much, as in joining two large tables. Even with where clauses the processing can take too much time. You can post the code but you really need to take your query to your DBA and ask what can be done with it.

Clint

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-***@LISTSERV.UGA.EDU]On Behalf Of
Kishore Kumar
Sent: Thursday, May 11, 2006 2:16 AM
To: SAS-***@LISTSERV.UGA.EDU
Subject: ERROR: Error fetching from cursor. ORACLE error is ORA-01555:
snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too
small.


Can some one help me.

I am unable to solve this problem.

when i am executing my program with obs=1 Crore it is working fine , but for obs=max i am unable to execute.

I am getting an error like this:-

ERROR: Error fetching from cursor. ORACLE error is ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too small.

Please suggest me some thing????


Waiting for your feedback.

Regards,
Kishore.K


---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.

[Pardee, Roy]

That's one to take to your DBA I think. I think it means your query is
taking too long to execute.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-***@LISTSERV.UGA.EDU] On Behalf Of
Kishore Kumar
Sent: Wednesday, May 10, 2006 11:16 PM
To: SAS-***@LISTSERV.UGA.EDU
Subject: ERROR: Error fetching from cursor. ORACLE error is ORA-01555:
snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too
small.

Can some one help me.

I am unable to solve this problem.

when i am executing my program with obs=1 Crore it is working fine ,
but for obs=max i am unable to execute.

I am getting an error like this:-

ERROR: Error fetching from cursor. ORACLE error is ORA-01555: snapshot
too old: rollback segment number 2 with name "_SYSSMU2$" too small.

Please suggest me some thing????


Waiting for your feedback.

Regards,
Kishore.K


---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.