The XDF comparison utility check database object definitions present in the XDF file with the database object definitions in the database and then applies the changes to the object in the target database accordingly.
Solution
adjava oracle.apps.fnd.odf2.FndXdfCmp
<schema_name>
<schema_Password>
<apps_schema>
<apps_Password>
<jdbc_protocol>
<jdbc_tnst_string>
<object_type>
<xdf_fileName>
<xsl_directory>
[deferred=<list>]
[dropCr=<list>]
[logfile=<filename>]
[Data_Sec_Vpd=<y|Y>]
[Standalone=<y|Y>]
[changedb=<y|n>]
Mandatory parameters of this utility
schema_name :schema name in which the object exists or should be created.
schema_Password :schema password in which the object exists or should be created.
apps_schema :schema name of current APPS schema.
apps_password :schema password of current APPS schema.
jdbc_protocol :jdbc driver type jdbc protocol (thin or oci8).
jdbc_tns_string :jdbc tns information either in format of Net8 connect string enclosed in double quotes or hostname:port:oracle_sid format.
object_type :Example , table, qtable, mview, mviewlog, sequence, type, trigger, view, policy
xdf_fileName :The xdf file name containing the object definition.
xsl_directory :The xsl directory having all the xsl files required for XSLT transformation. Normally its $FND_TOP/patch/115/xdf/xsl or $FND_TOP/admin/xdf/xsl.
Optional Parameters of this utility.
Deferred :List of indexes that needs to be deferred are mentioned in deferred argument seperated by comma.
DropCr :Constraints that needs to be dropped and recreated are mentioned in dropCr argument separated by comma.
Logfile :Logfile name for any debug data.
Data_Sec_Vpd :Allowed value is 'y '.
Standalone :Used when FndXdfCmp utility in a standalone mode. Allowed value is 'y '.
ChangeDb :The default value is 'y'. If value is specified as ‘n’ then the SQL statements generated by the utility are not executed but recorded in the log file.
----------
adjava oracle.apps.fnd.odf2.FndXdfCmp APPS oracle10g APPS oracle10g \
thin "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=erpintdb2_vip.koreanair.com)(PORT=1613))(ADDRESS=(PROTOCOL=tcp)(HOST=erpintdb1_vip.koreanair.com)(PORT=1613)))(CONNECT_DATA=(SERVICE_NAME=ERPTST2)))" \
mview \
/erptst2/apps/apps_st/appl/oki/12.0.0/patch/115/xdf/oki_srm_005_mv.xdf \
/erptst2/apps/apps_st/appl/fnd/12.0.0/patch/115/xdf/xsl
댓글 없음:
댓글 쓰기