[Q] How to online drop tempfile ?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Fri, 27 Aug 2004 07:58:24 -0700 (PDT)
Message-ID: <20040827145824.1028.qmail@web60810.mail.yahoo.com>

I am doing 9ir2 hot backup/recovery test. I got problem on tempfile (temporary tablespace) drop problem.

I can drop tempfile under "mount" mode, but NOT under database open:

SQL> startup mount
ORACLE instance started.

Total System Global Area 202880128 bytes

Fixed Size                   451712 bytes
Variable Size              83886080 bytes
Database Buffers          117440512 bytes
Redo Buffers                1101824 bytes

Database mounted.
SQL> alter database tempfile
'/apps/oradata/eaii/temp01.dbf' drop;

Database altered.

SQL> alter database open;

If I use same command when database open. It will hang in there for ever.

Can anyone tell me how to drop tempfile when database open?

Thanks.                 

---

Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out! 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_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 Fri Aug 27 2004 - 11:11:01 CDT