TEMPFILE cannot be dropped at this time [message #324784] |
Wed, 04 June 2008 00:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
laksha
Messages: 42 Registered: June 2006
|
Member |
|
|
One of the drives on my server having the tempfile is becoming full and I want to delete the tempfile on this drive and I will create aditional tempfile in other drive.
I tried using both these commands
ALTER DATABASE TEMPFILE '/u01/temp02.dbf' DROP
ALTER DATABASE TEMPFILE '/u01/temp02.dbf' DROP INCLUDING DATAFILES;
but this gives me error
Quote: | ORA-25152: TEMPFILE cannot be dropped at this time
| and then the tempfile goes offline.
I can use Dropping / Recreating Temporary Tablespace Method.
But i dont know why this droping tempfile doesnt work.
|
|
|
|
|
|