Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop a tempfile

happy10319May 15 2008 — edited May 29 2012

Hi,
in 8.1.7 I have a tempfile that does not exist physically :

SQL> select file_name, tablespace_name, status from dba_data_files where tablespace_name='TEMP';

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                STATUS
------------------------------ ---------
C:\ORACLE\ORA81\DATABASE\MISSING00004
TEMP                           AVAILABLE

C:\ORACLE\ORADATA\TEST\TEMPORARY_02B.DBF
TEMP                           AVAILABLE


SQL> host dir C:\ORACLE\ORA81\DATABASE\MISSING00004
 Volume in drive C has no label.
 Volume Serial Number is A01E-34E8

 Directory of C:\ORACLE\ORA81\DATABASE

File Not Found

And I want to drop it :

SQL> alter database drop TEMPFILE 'C:\ORACLE\ORA81\DATABASE\MISSING00004';
alter database drop TEMPFILE 'C:\ORACLE\ORA81\DATABASE\MISSING00004'
*
ERROR at line 1:
ORA-01900: LOGFILE keyword expected

How can I drop it ?
Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2012
Added on May 15 2008
5 comments
39,159 views