redundant rollback space

From: <>
Date: Mon, 6 Oct 2008 03:15:06 -0700 (PDT)
Message-ID: <>

I am working on a ee database on windows 2003

A tablespace that was available in 8i has been taken offline ( alter tablespace RBS offline ) 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

Original text of this message