SELECT INDEX_NAME,
table_name,
dbms_lob.substr(dbms_metadata.get_ddl('INDEX', INDEX_NAME),4000)
FROM DBA_INDEXES
WHERE TABLESPACE_NAME = 'MAXIMO_INDEX'
table_name,
dbms_lob.substr(dbms_metadata.get_ddl('INDEX', INDEX_NAME),4000)
FROM DBA_INDEXES
WHERE TABLESPACE_NAME = 'MAXIMO_INDEX'