RE: dbms package? - analyze table validate structure
Date: Fri, 2 Jan 2009 11:16:08 +0100
> > 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.
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.chReceived on Fri Jan 02 2009 - 04:16:08 CST