Begin
For i in (SELECT index_name FROM dba_indexes WHERE
tablespace_name=<tablespace_name>) loop
execute immediate 'analyze index <schema>.'||i.index_name||' validate
structure';

end loop;
end;

Deepak
-----Original Message-----
From: Katz Gil
[mailto:oracledba-ezmlmshield-x3963433.[Email address protected]
Sent: Wednesday, May 31, 2006 4:16 AM
To: LazyDBA Discussion
Subject: analyze index

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
=

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







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page