| 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
![]() |
![]() |