Generate Index DDL
vi index_ddl.sql
et heading off
set echo off
Set pages 999
set long 90000
set serveroutput on
set feedback off
spool ddl_list.sql
exec dbms_output.put_line('spool ddl_list.sql');
exec dbms_output.put_line('##################');
select dbms_metadata.get_ddl('INDEX','&index_name','&schema') from dual;
spool off;
set serveroutput off
set feedback on
