[Oracle]dbms_metadata.get_ddl的使用方法总结

set pagesize 0 set long 90000 set feedback off set echo off spool schema_ddl.sql select dbms_metadata.get_ddl('table',u.table_name,u.owner) from dba_tables u; select dbms_metadata.get_ddl('view',u.view_name,u.owner) from dba_views u; selec

set pagesize 0
set long 90000
set feedback off
set echo off
spool schema_ddl.sql
select dbms_metadata.get_ddl('table',u.table_name,u.owner) from dba_tables u;
select dbms_metadata.get_ddl('view',u.view_name,u.owner) from dba_views u;
select dbms_metadata.get_ddl('index',u.index_name,u.owner) from dba_indexes u;
select dbms_metadata.get_ddl('procedure',u.object_name, u.owner,) from dba_objects u where u.object_type = 'procedure';
select dbms_metadata.get_ddl('function',u.object_name, u.owner,) from dba_objects u where u.object_type = 'function';
spool off;

.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！