Temp File
Hello,
Currently i am woring on 10.2.0.3.0 i am facing a problem when i am droping it giving error
ERROR at line 1:
ORA-25152: TEMPFILE cannot be dropped at this time
it actual size at operating system is 31.29gb temp03.dbf but when i check through this command it giving 0 size.
what is the reason and please explain how can i drop this.
SQL> select STATUS,ENABLED,STATUS,BYTES/1024/1024 from v$tempfile;
STATUS ENABLED STATUS BYTES/1024/1024
------- ---------- ------- ---------------
OFFLINE READ WRITE OFFLINE 0
Regards,
Rehan