hi,
How to drop a temp file of temp tablespace?
SQL> Select file_name From Dba_Temp_Files;
FILE_NAME
--------------------------------------------------------------------------------
D:\ORACLE\ORADATA\ORCL\TEMP01.DBF
E:\ORACLE_DATA\TEMP02.DBF
SQL> Alter Tablespace TEMP
2 Drop Datafile 'E:\ORACLE_DATA\TEMP02.DBF';
Alter Tablespace TEMP
*
ERROR at line 1:
ORA-03219: Tablespace 'TEMP' is dictionary-managed, offline or temporary
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production