select dbms_lob.substr(dbms_metadata.get_ddl(‘index’, index_name))||’;’
from dba_indexes
where owner=’需要导出所有索引的用户’
refer to:
select dbms_lob.substr(dbms_metadata.get_ddl(‘index’, index_name))||’;’
from dba_indexes
where owner=’需要导出所有索引的用户’
refer to: