SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

increase roll back segment size

Ganesh SrivatsavAug 10 2007 — edited Aug 10 2007

Hi all,

i have this error.

ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6$"
too small
How can i increase the size of that rollback segment?
and corresponding tablespace also.
how can i know to which tablespace does this roolback segment belong to?

Any ideas?

Thanks,

G.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2007

Added on Aug 10 2007

12 comments

8,612 views