create a index rebuilding script

[gtcol]

Just replace the second select statement with this:

select index_name "SORT1",
'2' "SORT2",
'select '''||index_name||''', to_char(sysdate,'||'''dd-Mon-yyyy hh24:mi:ss'''||') from dual;' "CMDLINE"
from dba_indexes
where owner = 'SCOTT'
;
/

HTH,
gtcol

[hafeezkalsekar]

thankz gtcol.
gr8