Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1578
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
![]() |
![]() |