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.