resize rollback segemnt

[shailendra]

hi

I want one help from all of you friends I have a rollback segment data file having occupying huge space, I do not want that much space now i want to reduct that space how do i reduce?

I WANT TO RESIZE THE ROLLBACK SEGMENT DATA FILE.

Thanks in advance
Shailendra

[soniaarora]

U can simply drop this rollback segment and create a new one with a smaller size

[Tarry]

Something like this.........

alter rollback segment xyz offline;
drop rollback segment xyz;
alter database datafile '/blah/dbs/xyz.dbf' resize 100M;
create rollback segment xyz
storage ( initial 1024k next 1024k minextents 20 ) tablespace rbs;
alter rollback segment xyz online;

Should help.

Cheers!!

[shailendra]

I have tried the above syntax but I am getting this error

ORA-03297: file contains used data beyond requested RESIZE value

Shailendra

[Sameer]

That means there are few more segments above the requested size...

either drop those segments or resize at higher value...

Sameer

[nagarjuna]

Originally posted by shailendra
I have tried the above syntax but I am getting this error

ORA-03297: file contains used data beyond requested RESIZE value

Shailendra

Drop all the RBS in that tablespace and try resizing.

[shailendra]

When I try to resize it more then what it had then it is working but when I try to reduce it, it is not working.


Shailendra

[prakashs43]

try this command
alter rollback segment ... shrink;

and then try to reduce the datafile .