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

Hello,

I saw your query. I suggest that you first take the tablespace offline ....

ALTER TABLESPACE TEMP_SPACE OFFLINE; and then drop it .......

DROP TABLESPACE TEMP_SPACE INCLUDING CONTENTS ..including contents ,,,if you have data in the tablespace..

Please note that a tablespace still holding data cannot be dropped with out the INCLUDING CONTENTS

Regards
Bosco

The message recieved....

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 Fri Oct 06 2000 - 01:24:02 CDT