RE: ORA-01135 selecting from the view
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <ikar@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Jul 2006 12:22:29 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Inessa Weiner
Sent: Wednesday, July 12, 2006 12:03 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
