Script to generate DDL for indexes?
Hi,
I tried this:
running as the index owner:
set pagesize 0
set long 90000
set feedback off
set echo off
spool index_dd.slq
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
FROM USER_INDEXES u;
spool off
But the output lacks a / or ; at the end of every index. How to fix that?
Regards
S