dbms package? - analyze table validate structure
- From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Dec 2008 11:37:29 -0500
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
- Follow-Ups:
- Re: dbms package? - analyze table validate structure
- From: Bradd Piontek
- Re: dbms package? - analyze table validate structure
- From: Jared Still
- Re: dbms package? - analyze table validate structure
- References:
- Re: how to login as "SYS" on sqlplus
- From: Fuad Arshad
- Re: how to login as "SYS" on sqlplus
Other related posts:
- » dbms package? - analyze table validate structure - Crisler, Jon
- » Re: dbms package? - analyze table validate structure - Bradd Piontek
- » Re: dbms package? - analyze table validate structure - Alex Fatkulin
- » RE: dbms package? - analyze table validate structure - Crisler, Jon
- » Re: dbms package? - analyze table validate structure - Jared Still
- » RE: dbms package? - analyze table validate structure - Crisler, Jon
- » Re: dbms package? - analyze table validate structure - Alex Fatkulin
- » RE: dbms package? - analyze table validate structure - M Rafiq
- » RE: dbms package? - analyze table validate structure - Crisler, Jon
- » Re: dbms package? - analyze table validate structure - Tim Gorman
- » RE: dbms package? - analyze table validate structure - M Rafiq
- » Re: dbms package? - analyze table validate structure - Tim Gorman
- » RE: dbms package? - analyze table validate structure - M Rafiq
- » RE: dbms package? - analyze table validate structure - Christian Antognini
- » Re: dbms package? - analyze table validate structure - Alex Fatkulin
- » RE: dbms package? - analyze table validate structure - Yong Huang
- » RE: dbms package? - analyze table validate structure - Crisler, Jon
- » RE: dbms package? - analyze table validate structure - Yong Huang