SELECT dbms_lob.substr(DBMS_METADATA.get_ddl ('INDEX', index_name),5000,1)
FROM user_indexes
--WHERE TABLE_NAME = 'TEST'
;