Re: [Q] How to online drop tempfile ?
- From: "Darrell Landrum" <darrell@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 28 Aug 2004 09:59:34 -0500
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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <oracledba@xxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
