Hi Guys,

My RBS tablespace has grow to 1.6Gb during some heavy transactions. I have check one the rollback segments. All of them
OWNER SEGMENT_NAME TABLESPACE BYTES EXTENTS
------------------------------ ---------- ----------------- SYS RBS0 RBS 4194304 8
SYS RBS1 RBS 4194304 8
SYS RBS2 RBS 4194304 8
SYS RBS3 RBS 4194304 8
SYS RBS4 RBS 4194304 8
SYS RBS5 RBS 4194304 8
SYS RBS6 RBS 4194304 8



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

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


I have tried to coalesce and it doesn;t change anythign on the HWM. I did issue a resize on the datafile and it does not work :

SQL> alter database datafile '/opt/oracle/oradata/irmsitdb/rbs01.dbf' resize 1500m;
alter database datafile '/opt/oracle/oradata/irmsitdb/rbs01.dbf' resize 1500m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

I have perform this on other tablespaces including TEMp and it works.

What can be done to reduce the size of my RBS tablespace's datafile??