redundant rollback space
Date: Mon, 6 Oct 2008 03:15:06 -0700 (PDT)
I am working on a 10.2.0.3 ee database on windows 2003
A tablespace that was available in 8i has been taken offline
( alter tablespace RBS offline )
..in anticipation of dropping as it was thought it was not being used.
When I ran a truncate command got the following error
truncate table insert_failure_log drop storage
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 70 cannot be read at this time ORA-01110: data file 70: 'H:\ORACLE\ORADATA\DM2\RBS02.ORA'
How can I tell which tablespaces are used by the database for rollback ?
Show parameters didn't refer to the RBS tablespace
undo_management string AUTO undo_retention integer 900 undo_tablespace string undo_rbs1 use_indirect_data_buffers boolean FALSE
My goal was to save space by removing a redundant tablespace
Chris B Received on Mon Oct 06 2008 - 05:15:06 CDT