Re: Drop old fashioned rollback tablesspace

Kurt-Erich.Finger_at_hte-company.de wrote:
> We migrated a database from 8.1.7 to 10G. We still have the roll-back
> tablespace (and also the undo tbs). Is it save to take the roll-back
> tablespace offline and delete the datafile? In the DBA_ROLLBACK_SEGS I
> find only records with the tablespace_name SYSTEM and UNDOTBS1.
> Thanks

SELECT value
FROM v$parameter
WHERE name LIKE 'undo%'

If undo_management = AUTO
and undo_tablespace is listed
Then off-line the rollback tablespace.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)