RE: dbms package? - analyze table validate structure

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 2 Jan 2009 11:16:08 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF013D7AB8_at_MSXVS04.trivadis.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 02 2009 - 04:16:08 CST

This message: [ Message body ]
Next message: Martin Berger: "different physical access method because of disabling Automated Memory Management?"
Previous message: Stephane Faroult: "Re: Re: How to improve performance using Oracle Spatial"
Next in thread: Alex Fatkulin: "Re: dbms package? - analyze table validate structure"
Reply: Alex Fatkulin: "Re: dbms package? - analyze table validate structure"
Maybe reply: Yong Huang: "RE: dbms package? - analyze table validate structure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message