RE: dbms package? - analyze table validate structure
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- Date: Fri, 2 Jan 2009 11:16:08 +0100
Hi Jon
> > Jon, you may consider using RMAN's
> >
> > backup [validate] check logical ....
>
> Interesting, I did think about this option, I will look into that.
AFAIK only ANALYZE is able to find inconsistencies between data and
index blocks (e.g. ORA-01499: table/index cross reference failure). As a
result, RMAN with CHECK LOGICAL is of limited for corrupted indexes.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
Other related posts:
