1、dbms_metadata.get_ddl
set pagesize 0
set long 90000
set feedback off
set echo off
spool get_ddl.sql
select dbms_metadata.get_ddl(‘TABLE‘,‘tablename‘,‘username‘) from dual;
select dbms_metadata.get_ddl(‘VIEW‘,‘viewname‘,‘username‘) from dual;
select dbms_metadata.get_ddl(‘INDEX‘,‘indexname‘,‘username‘) from dual;
spool off;
2、imp.indexfile
1)先导出用户的数据
[[email protected] ~]$ exp scott/scott file=test.dmp owner=scott log=test.log;
2)从 dump 文件获取这些 DDL 语句
[[email protected] ~]$ imp scott/scott file=test.dmp fromuser=scott touser=scott indexfile=test.sql;
3、impdp.sqlfile
导出用户数据
[[email protected] ~]$ expdp scott/scott directory=DATA_PUMP_DIR dumpfile=sqlfile.dmp schemas=scott;
获取 DDL 语句
[[email protected] ~]$ impdp scott/scott directory=DATA_PUMP_DIR dumpfile=sqlfile.dmp sqlfile=scott.sql;
原文：https://www.cnblogs.com/ss-33/p/12923230.html
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/224073.html原文链接：https://javaforall.net
