| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: datafile corrupt?
On Sat, 22 Aug 1998 1:25:00 +0200, Yat-Fan wrote
(in message <6rkv2d$scu_at_ustsu10.ust.hk>):
>
> Hello all,
>
> I have a problem regarding Oracle on NT (actually Oracle 8.0.4, but the
> question should be general):
>
> I ran a query to delete selective data from a large table, and the query
> failed with a message that the data file (on NTFS) where the indexes of the
> large table resides corrupts. The file no, block no etc are indicated.
>
> I think this is a common problem? Can anyone advise me with some
> suggestions to proceed?
You are quite lucky it's only an index space. Find out which index got hurt by checking DBA_SEGMENTS and rebuild the index(es). It happened to me on a data tablespace using oracle 7.3.4 and that was a bit more problem.
Cheers,
--
Ronald
 |
 |