<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">--输出信息采用缩排或换行格式化</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'PRETTY', TRUE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">--确保每个语句都带分号</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'SQLTERMINATOR', TRUE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">--关闭表索引、外键等关联（后面单独生成）</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'CONSTRAINTS', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'REF_CONSTRAINTS', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'CONSTRAINTS_AS_ALTER', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">--关闭存储、表空间属性</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'STORAGE', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'TABLESPACE', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">--关闭创建表的PCTFREE、NOCOMPRESS等属性</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">EXEC DBMS_METADATA.set_transform_param(DBMS_METADATA.session_transform, 'SEGMENT_ATTRIBUTES', FALSE);</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;">SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name, u.owner)</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;"> FROM dba_objects u</span><br style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;" />
<span style="font-family:宋体;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;"> where owner like 'TACCCYUC%' ;</span>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25462274/viewspace-1936616/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
等待事件脚本
下一篇：
rman_trun_arch.sh
请登录后发表评论
登录
全部评论
