Hi

I want to analyze all the indexes in my schema

I know that the sql statement to get the indexes list is

SELECT index_name FROM dba_indexes WHERE
tablespace_name=<tablespace_name>;

And to analyze index I have to

analyze index <schema>.<index_name> validate structure;

how do I combine the two?



Gil Katz

QA Engineer

AppSight J2EE Team

Identify Software Ltd.

UIN 1538854

Tel: +972 (3) 9101927

=================================================

= So Long, and Thanks for All the Fish
=

=================================================






Oracle LazyDBA home page