dbms_metadata.get_ddl - Index DDL
spool create_index.sql
define schemaname=&&1
define indexname=&&2
set heading on
set echo off
set flush off
set pagesize 9999
set linesize 9999
set long 9999
column ddl format a150
select dbms_metadata.get_ddl('INDEX','&&indexname','&&schemaname') ddl FROM DUAL;
spool off