how to delete tablespace "TEMP" data file normally? [message #310130] |
Mon, 31 March 2008 06:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
wxfjordan
Messages: 92 Registered: December 2006
|
Member |
|
|
SQL> select file_name, status, file_id from dba_temp_files;
FILE_NAME STATUS FILE_ID
--------------------------------------------- --------- ----------
/u01/app/oracle/oradata/msi/temp01.dbf AVAILABLE 1
+DATA/msi/tempfile/temp.264.650818167 AVAILABLE 2
"+DATA" is ASM diskgroup. Another is file system folder.
how to delete tablespace "TEMP" data file normally?
|
|
|
Re: how to delete tablespace "TEMP" data file normally? [message #310134 is a reply to message #310130] |
Mon, 31 March 2008 06:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
wxfjordan
Messages: 92 Registered: December 2006
|
Member |
|
|
My step is following. Is this normally?
SQL> alter database tempfile '/u01/app/oracle/oradata/msi/temp01.dbf' offline;
Database altered.
SQL> alter database tempfile '/u01/app/oracle/oradata/msi/temp01.dbf' drop;
Database altered.
SQL> select file_name, tablespace_name, status, autoextensible from dba_temp_files;
FILE_NAME TABLESPACE_NAME STATUS
--------------------------------------------- ----------------- ---------
+DATA/msi/tempfile/temp.264.650818167 TEMP AVAILABLE
|
|
|
|
|