Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stat.delete_schema_stats and gather_schema_stats ignore nested tables
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 Received on Mon Jun 06 2005 - 17:03:09 CDT