Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables

<fitzjarrell_at_cox.net> wrote in message
news:1118095389.333996.314610_at_g49g2000cwa.googlegroups.com...
>
>
> flavio_at_tin.it wrote:
> > Just to report that after upgrading the db to patch level 9.2.0.6.0,
> > the problem persists.
> >
> > Indexes on nested tables are NOT computed by
> > dbms_stats.gather_schema_stats with cascade = true.
> >
> > Bye,
> > Flavio
>
> DBMS_STATS is not designed to follow nested tables and their indexes.
> You have found your solution by supplying the nested table name and
> using CASCADE=>true, so use it.
>
>
> David Fitzjarrell
>

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=486985.995

Bye,
Flavio Received on Tue Jun 07 2005 - 15:05:23 CDT