oracle创建cmp表,Oracle Apps ADODFCMP Utility

(Object Descriptor File),里边含有数据库对象的描述，用于创建数据库表，视图，索引等等。

除了打patch可以打odf文件，我们还有个手工打odf的工具叫做ADODFCM($AD_TOP/bin下),名字拆开比较好记，AD表示Admin，ODF表示Object Descriptor File，CM表示Compilation。

应用场景，比如发现数据库某张表没有被创建，但odf文件其实是有定义的，这个时候打patch比较麻烦，可以考虑使用ADODFCM

odf文件的位置

$PROD_TOP/patch/115/xxx.odf

adodfcmp用法

[oracle@bej301441 odf]$ cd $INV_TOP/patch/115/odf/

[oracle@bej301441 odf]$ adodfcmp odffile=invslig.odf userid=inv/inv changedb=yes priv_schema=system/manager mode=indexes touser=apps/apps logfile=invtab.log

adodfcmp parameters

parameters are required: mode, touser, priv_schema, odffile, userid

mode (required) :Determines the type of objects to compare against the ODF.Example tables,indexes

touser (required) : Specifies the Oracle username/password of the Oracle Applications product to grant to. In Release 11i/R12 this is usually APPS schema.

priv_schema (required) :Specify a schema having DBA privileges, along with its password. You may specify the SYSTEM schema

odffile (required) : The name of the object descriptor file (file extension .odf) to compare.

userid (required) :The Oracle username/password for the product’s base schema. This is the schema where the product tables, indexes and sequences are located for example inv/inv

changedb (opt) No :Set to yes to change the database objects to match the definitions in the object descriptor files. Customizations are not affected because the utility does not delete objects not found in the ODF. Using the default, No, will not make anychanges only produce a log file indicating what changes need to be made.

Sample Log

************* Start of ODF Comparison Utility session *************

ODF Comparison Utility version: 12.0.0

ODF Comparison Utility started at: Tue Jul 31 2012 00:21:00

Connecting to SYSTEM......Connected successfully.

Connecting to APPS......Connected successfully.

Reading objects from ODF file

Reading table MTL_CLIENT_PARAMETERS ...

Reading table MTL_TXNS_HISTORY ...

Reading table MTL_BILLING_SOURCES_B ...

Reading table MTL_BILLING_SOURCES_TL ...

Reading table MTL_BILLING_RULE_HEADERS_B ...

Reading table MTL_BILLING_RULE_HEADERS_TL ...

Reading table MTL_BILLING_RULE_LINES ...

Reading table MTL_3PL_LOCATOR_OCCUPANCY ...

Reading table MTL_ADJUSTMENT_SYNC_TEMP ...

Reading table MTL_LSP_ONHAND_BALANCE_TMP ...

....

....

...

Start time for statement below is: Tue Jul 31 2012 00:21:03

ALTER TABLE INV.MTL_LSP_ONHAND_BALANCE_TMP STORAGE (FREELISTS 4)

Statement executed.

ODF Comparison Utility is complete.

You should check the file

/u01/oracle/instance/apps/apps_st/appl/inv/12.0.0/patch/115/odf/invtab.log

for errors.

转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7814422

===EOF===