Oracle 导出用户下的所有索引创建语句
程序员文章站
2023-12-27 23:28:15
SELECT dbms_lob.substr(dbms_metadata.get_ddl('INDEX', INDEX_NAME))||';' from dba_indexes where owner='需要导出所有索引的用户' refer to:https://www.cnblogs.com/lh ......
select dbms_lob.substr(dbms_metadata.get_ddl('index', index_name))||';'
from dba_indexes
where owner='需要导出所有索引的用户'
refer to: