ORACLE目录所有SQL导出

ORACLE索引所有SQL导出
SELECT INDEX_NAME,
       table_name,
       dbms_lob.substr(dbms_metadata.get_ddl('INDEX', INDEX_NAME),4000)
  FROM DBA_INDEXES
WHERE TABLESPACE_NAME = 'MAXIMO_INDEX'