RE: [Q] how to "offline drop" a temporary temporary tablespace?

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Thu, 5 Oct 2000 14:57:42 -0700
Message-Id: <10640.118656@fatcity.com>

drop tablespace temp;

-----Original Message-----
From: L [mailto:leed_at_chele.cais.net]
Sent: Thursday, October 05, 2000 2:44 PM To: oracle-l_at_fatcity.com; oracledba_at_quickdoc.co.uk Subject: [Q] how to "offline drop" a temporary temporary tablespace?

I have a ORACLE database 8.1.6 and have a "temporary temporay" tablespace want to drop. I tried following and not successful.

  SQL> alter tablespace temp_space offline drop;

       alter tablespace temp_space offline drop
                                    *
       ERROR at line 1:
       ORA-02141: invalid OFFLINE option


      SQL> alter tablespace temp_space offline;
           alter tablespace temp_space offline
           *
           ERROR at line 1:
           ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Can anyone give me a hint how to do it?

Thanks.

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Thu Oct 05 2000 - 16:57:42 CDT