Re: Question on create more space for rollback segment

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 11 Dec 1998 14:14:48 GMT
Message-ID: <01be2510$f0742300$a12c6394@J00679271.ddc.eds.com>

Forgot to include requested commands in my reply: Item in [] are comments:

alter tablespace rbs [or correct name]
add datafile '/dir/sub-dir/desired_file_name.dbf' size 64M [or desired size]
/

cw98_at_my-dejanews.com wrote in article <74pcgf$12e$1_at_nnrp1.dejanews.com>... .......>
> 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.
>
> Can someone give me a step-by-step list of the commands
> that I should run to create more space for the rollback
> segment.
>
Received on Fri Dec 11 1998 - 08:14:48 CST