Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01135 selecting from the view

ORA-01135 selecting from the view

From: Inessa Weiner <ikar_at_med.cornell.edu>
Date: Wed, 12 Jul 2006 14:02:36 -0400
Message-id: <5.1.0.14.2.20060712135722.037c7918@pop.med.cornell.edu>


Hello,

I am getting the following error
selecting from the view

select count(*) from v_xxx;

ERROR at line 1:
ORA-01135: file 5 accessed for DML/query is offline ORA-01110: data file 5: '/db011/oradata/.dbf'

It worked fine for are very long time even earlier today too. The datafile is offline for many years already and we did not have problems before.

Please help.

Thanks.
Inessa.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 12 2006 - 13:02:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US