Re: DBMS_REPAIR Package

From: Daniel Fink <daniel.fink_at_sun.com>
Date: Thu, 17 Jul 2003 12:04:23 -0600
Message-Id: <25946.338289@fatcity.com>

This is a multi-part message in MIME format.

--------------F8281B8F9BBE2348211B2E4E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

There's a good argument for separating tables/indexes.

Jared.Still_at_radisys.com wrote:
>
> If you ran dbverify with the database up, it's very likely that
> there is nothing wrong with the datafiles.
>
> If dbv reads a block in transition, it will appear corrupt.
>
> Run it again, and there will either be no errors, or they will
> appear to be in different blocks.
>
> Personally, I think it a colossal waste of time to run dbverify.
>
> In 9 years of DBA'ing, I've experienced maybe 3 or 4 instances
> of a corrupt block, and it was always an index. The solution
> was to drop/rebuild the index.
>
> Jared

--------------F8281B8F9BBE2348211B2E4E
Content-Type: text/x-vcard; charset=us-ascii;  name="daniel.fink.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Daniel Fink
Content-Disposition: attachment;

 filename="daniel.fink.vcf"

begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

--------------F8281B8F9BBE2348211B2E4E-- Received on Thu Jul 17 2003 - 13:04:23 CDT