Re: ORA-1578

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 02 Jun 1999 09:32:46 -0700
Message-ID: <37555CAE.AC913326@us.oracle.com>

A point of clarification. You can copy all the rows EXCEPT the bad block in a number of ways. Support has a bulletin that covers this. In addition, in 8i you can make the block software corrupt so that Oracle ignores it.

Pete

Pradhan wrote:

> 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.
> >
> >

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Jun 02 1999 - 11:32:46 CDT