Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> [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? Received on Thu Oct 05 2000 - 16:44:19 CDT
![]() |
![]() |