5 Replies Latest reply: Mar 3, 2013 2:14 AM by Maahjoor RSS

    how to confirm that a specific datafile has data

    Maahjoor
      Dear all,
      i am using oracle 10gr2 on windows server 2003.
      i have the following query
      SQL> select name from v$datafile;
      
      NAME
      -------------------------------------------------------------
      G:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\SYSTEM01.DBF
      G:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\UNDOTBS01.DBF
      G:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\SYSAUX01.DBF
      G:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\USERS01.DBF
      G:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\EXAMPLE01.DBF
      C:\WINDOWS\SYSTEM32\TBS_F2.DAT
      how would i know that C:\WINDOWS\SYSTEM32\TBS_F2.DAT has user data. actually i want to drop this file.

      Thanks.