-
unable to resize a RBS tablespace
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??
Regards
CF
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|