Hi Julian,

I think i have a similar script and the values are as below for my RBS ( as from my 1st thread)

File Name Size (M) Used (M) Free (M) HWM (M)
---------------------------------------- ---------------------------
/opt/oracle/oradata/mydb/rbs01.dbf 1600 28 1069 1588

From above, my RBS tablespace is using 28Mb only, and 1.5Gb at HWM.

I should be able to downsize a free space of 1.5gb, but i can't.


Could i do the following :
1) create another seperate RBS tablepsace and create some public rollback segments in that tablepace.
2) offline those current rollback segments in the oversize tablespace, and drop the tablespace.
3) Create back the dropped RBS with a smaller datafile size, and recreate back those drop rollback segments.

Will this work?