Re: HELP!Rollback segment

In article <8rqgkt$d00$2_at_coco.singnet.com.sg>,   kowho_at_singnet.com.sg (Ho) wrote:
> I have added a datafile RBS2orcl.ora to my PC.
>
> How to remove this datafiles ?
>
> I tried to resize the data file, I get :
> ORA-03297: file contains 2499 blocks of data beyond requested RESIZE
> value.
>
> How to know what is the min size to reduced to ?
>
> How to know which rollback segment is using this datafile
> rbs2orcl.ora & rbs1orcl.ora ?
>
> Many thanks for your help in advance.
>

Start by looking at sys.dba_rollback_segs. Amoung other information the rbs segments names and tablespaces appear here.

I do not believe in expandable database files. They are more trouble than they are worth. One runaway insert program can eat the entire disk drive.

Your rbs tablespace needs to be large enough to hold all the assigned rbs segments plus allow the segments to grow while in use to support the largest transaction that your system should be able to support. Do not forget that you will need rbs area for maintenance jobs.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.