RE: ORA-01135 selecting from the view

From oerr:

$ oerr ora 01135
01135, 00000, "file %s accessed for DML/query is offline" // *Cause: Attempted to access a data file that is offline // *Action: Bring the data file back online

The datafile is offline. Bring it on line.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Inessa Weiner Sent: Wednesday, July 12, 2006 12:03 PM
To: oracle-l_at_freelists.org
Subject: ORA-01135 selecting from the view

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

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--

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