Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> [Q] how to "offline drop" a temporary temporary tablespace?

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

From: L <leed_at_chele.cais.net>
Date: Thu, 5 Oct 2000 17:44:19 -0400 (EDT)
Message-Id: <10640.118655@fatcity.com>


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? Received on Thu Oct 05 2000 - 16:44:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US