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导出导入时仅导入数据后创建索引~
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导出导入时仅导入数据后创建索引~