Question on create more space for rollback segment

From: <cw98_at_my-dejanews.com>
Date: Thu, 10 Dec 1998 20:55:45 GMT
Message-ID: <74pcgf$12e$1@nnrp1.dejanews.com>

Folks,

I get the following error when attempting to run an update on an Oracle7 server:

ERROR at line 1:
ORA-01562: failed to extend rollback segment number 2 ORA-01650: unable to extend rollback segment R01 by 1024 in tablespace RBS

I tried to allocate more space for the rollback segment using 'alter rollback segment' but I am still getting the same error.

My questions is:

Do I need to create a data file that correspond to the new space that I am allocating to the rolback segment? How do I do that?

Can someone give me a step-by-step list of the commands that I should run to create more space for the rollback segment.

regards,
-cw

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 10 1998 - 14:55:45 CST