looks like the blocks were all allocated to a single large table. I
truncated the table and imported from a previous export. its reatvily
static data. i was then able to export the entier db. we will chuck the
disk out now.
"Adrian Carlson-Hedges" <adrian.ch_at_btinternet.com> wrote in message
news:9tjl68$f5v$1_at_uranium.btinternet.com...
> Are you running in archive log mode? Do you have a (recent) backup of the
> database?
>
> If yes, and yes, you should be able to get to where you were before the
> error occurred, by simply shutting down the database, copying across the
> backup of that file, restarting the database and recovering it. (This is a
> gross simplification, with lots of steps missing)
>
> If not I seem to remember it's possible to tell Oracle to ignore certain
> 'bad' blocks. Of course this might well leave a hole in your data.Off the
> top of my head I can't remember how, but I don't think all is lost.
>
> Adrian
>
> "ed zappulla" <zappullae_at_rcn.com> wrote in message
> news:9tivpv$ap$1_at_bob.news.rcn.net...
> > I'm getting the following errors. can it be fixed?
> >
> > ora 8.1.6, win2k pro
> >
> > EXP-00056: ORACLE error 1115 encountered
> > ORA-01115: IO error reading block from file 3 (block # 94834)
> > ORA-01110: data file 3: 'C:\ORA81\ORADATA\ORACLE\USERS01.DBF'
> > ORA-27091: skgfqio: unable to queue I/O
> > OSD-04006: ReadFile() failure, unable to read from file
> > O/S-Error: (OS 23) Data error (cyclic redundancy check).
> >
> >
> >
>
>
Received on Fri Nov 23 2001 - 07:44:02 CST
