Hi there,

Is there a way to rebuild all index!

I don't want to do one at a time:

Alter index rebuild;


or this:

SELECT 'alter index '|| owner||'.'||index_name||' rebuild;'
FROM all_indexes;


Please guide me!!

thanks