代码改变世界

工作流移植命令

2015-12-15 15:20  TRACEING  阅读(438)  评论(0编辑  收藏  举报

Upload
WFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <file_name.wft>
把工作流文件(wft文件)上传到数据库中
Example:-
WFLOAD apps/apps@instance 0 Y UPLOAD ABCDEFG.wft

Different “Upload Modes” applicable to WFLOAD
UPLOAD  - Honors only protection level of data [No respect of Customization Level]
UPGRADE – Honors both protection and customization levels of data
FORCE   - Force upload regardless of protection or customization level
注:
WFLOAD必须大写,小写的话Unix下会报command not found
一般情况下Oracle的patch(含有工作流文件)都是使用UPGRADE模式传入数据库的,这样就不会覆盖客户化的workflow的内容了。
默认wft源文件放在$<PRODUCT_TOP>/patch/115/import/<LANG>目录下。


Download
WFLOAD <apps_user_name>/<password>@db 0 Y DOWNLOAD file_name.wft <Item_Type>
把数据库中的Item Type读取成wft文件
Example:-
WFLOAD apps/apps@instance 0 Y DOWNLOAD ABCDEFG.wft PTLEAVE