导出用户索引创建语句

SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)　FROM dba_INDEXES u where owner in ('VER_LINK2','WMSSA2','WMSCOM2','WMSDHDDY2','WMSORA2','ZKRORA2','ZKRDHDDY2')；

 

 

可实现exp/imp导出导入时仅导入数据后创建索引~