Hi Hrishy,

This is the output:

Code:
QL> select file#,name,status,enabled from v$datafile where file#=2724;

     FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS  ENABLED
------- ----------
      2724
+VGROUP36/dbh/datafile/img3_id_2008_02_12.365.648647395
ONLINE  DISABLED
So i can see that enabled is set to disabled meaning no sql access is possible even thoough the file is online? Is this the problem?
How does one enable this?

Thanks in advance!