RE: dbms package? - analyze table validate structure

Interesting, I did think about this option, I will look into that.  I
did discover something called DBMS_REPAIR that might work as well.

-----Original Message-----
From: Alex Fatkulin [mailto:afatkulin@xxxxxxxxx] 
Sent: Wednesday, December 31, 2008 12:24 PM
To: Crisler, Jon
Cc: piontekdd@xxxxxxxxx; oracle-l
Subject: Re: dbms package? - analyze table validate structure

Jon, you may consider using RMAN's

backup [validate] check logical ....

for there purposes as well

check logical might be a part of you regular backups thus you can
introduce it more or less transparently, reference
v$database_block_corruption after that....

On Wed, Dec 31, 2008 at 11:55 AM, Bradd Piontek <piontekdd@xxxxxxxxx>
wrote:
> Jon,
>   No, I believe 'analyze' is the way to go on this. Just roll it into
a
> package using EXECUTE IMMEDIATE .
>
> HTH
>
> Bradd Piontek
>   "Next to doing a good job yourself,
>         the greatest joy is in having someone
>         else do a first-class job under your
>         direction."
>  -- William Feather
>
>
> On Wed, Dec 31, 2008 at 10:37 AM, Crisler, Jon <Jon.Crisler@xxxxxxx>
wrote:
>>
>> Does anybody know if there is an equivalent Oracle provided package
like
>> DBMS_STATS that does the same thing as "analyze table (name) validate
>> structure" ?  I have a system that seems to encounter corrupted
indexes
>> now and then, am I want to implement a preventative process via
dbms_job
>> to check all the tables and indexes in a particular schema.
>>
>> Thanks in advance.
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>
>



-- 
Alex Fatkulin,
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Other related posts: