通过获取表和索引DDL的简单方法：
set heading off;set echo off;Set pages 999;set long 90000;spool ddl_list.sqlselect dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;spool off;
通过获取表和索引DDL的简单方法：
set heading off;set echo off;Set pages 999;set long 90000;spool ddl_list.sqlselect dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;spool off;名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
