Re: ORA-1578

From: Jan H Malmberg <jhma_at_gbg.ifsab.se>
Date: Wed, 2 Jun 1999 18:38:39 +0200
Message-ID: <7j3mrb$efp$1@vega.lejonet.se>

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