Re: ORA error 1115 during export

It may well be a hard drive problem. Try running dbv (DB Verify) on it. Unfortunately dbv is almost always too optimistic. If no error found, at OS level try copying this datafile to the same directory to a different filename. If fails, that's it. Also have your OS system admin take a look at this error. Finally call Oracle Support. I experienced similar problems in importing a few weeks ago. It was our hard drive.

Yong Huang

In article <390B1637.23188D04_at_yahoo.com>,   Nikita <Nikita_at_yahoo.com> wrote:
> We are running Oracle 8.0.5.2 on Solaris 2.7
>
> A couple of times now during a full export of our database, we receive
> the following error message:
>
> EXP-00056: ORACLE error 1115 encountered
> ORA-01115: IO error reading block from file 12 (block # 262145)
> ORA-01110: data file 12: '/apps/ora_disk04/OMNI/omni04.dbf'
> ORA-27072: skgfdisp: I/O error
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 262127
>
> Does this indicate that there could be problems with this particular
> disk, and if so, why are exports successful all other times?
>
> Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 01 2000 - 00:00:00 CDT