redundant rollback space

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

cheers
Chris B Received on Mon Oct 06 2008 - 05:15:06 CDT