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. >> -- >> //www.freelists.org/webpage/oracle-l >> >> > > -- Alex Fatkulin, http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l