Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1578
You should be able to fetch rows from the blocks not corrupted with the help
of rowid.
SELECT * FROM table WHERE rowid < [some value] OR rowid > [some value]
avoiding to touch the corrupted block.
JhMa
Pradhan <empradhan_at_dplus.net> wrote in message
news:Oj253.503$Y5.2795_at_newsfeed.slurp.net...
> Hi
> to my knowlege Nope.. .. once you hit 1578 your out of luck.
> Thats my experience and did consulted with Oracle Customer Support
> but no success.
> May be some one out there may have some better view on this..
>
> Good luck.
> Pradhan
>
> Narcís Borrell wrote in message <7j0ivo$o0m$1_at_talia.mad.ttd.net>...
> >
> > Is there a way to copy the good rows of a table affected with a block
> >corruption.
> >
> >
>
>
Received on Wed Jun 02 1999 - 11:38:39 CDT
![]() |
![]() |