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 |