One answer is to drop, then recreate the whole temp tablespace.
Since this is a temporary type tablespace, and if it is not in use at the
moment, this operation should take no longer than a second.
- Original Message -----
From: "dba1 mcc" <mccdba1_at_yahoo.com>
To: <oracle-l_at_freelists.org>; <oracledba_at_LazyDBA.com>
Sent: Friday, August 27, 2004 9:58 AM
Subject: [Q] How to online drop tempfile ?
> I am doing 9ir2 hot backup/recovery test. I got
> problem on tempfile (temporary tablespace)
> drop problem.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
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
-----------------------------------------------------------------
Received on Sat Aug 28 2004 - 09:55:08 CDT
