FTS or exporting the table to /dev/null does not necessarily do a
block clean out. If the blocks are already in the cache as a CR buffer
(or an current buffer with undo buffers are in cache) it can be used to
construct the block images and no clean outs are necessary.
You can offline the undo segments and drop the undo tablespace if there
are no active transactions using that segment. Active transactions
using that undo segments can be found from (KTUXE) which is exposed as
V$transaction.
The other alternative is to wait for some (!) more time and once all
the transactions vacates the old undo tablespace, you can safely drop
the tablespace.
=====
Have a nice day !!
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004.
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
