adodfcmp

Hi Dba's

Having a bit of a problem using adodfcmp

I can't apply the file the file that oracle sent me.
I am using the following command and no luck.


adodfcmp odffile=pomrc2.odf userid=apps/apps changedb=yes

Copyright (c) 1998 Oracle Corporation
Redwood Shores, California, USA

ODF (Object Description File) Comparison Utility

Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

ODF Comparison Utility - adodfcmp: ERROR: You need to supply the mode argument


What am I doing wrong. This is the first time I'm using it. Any idea what I am suppose to do???

You are missing the mode parameter - as the error message indicates. The odf file contains definitions for views, tables, etc. Since you have changedb=yes - which means you want the adodfcmp utility to read the odf file and apply the changes to the database you need to also specify what sort of changes you are performing. i.e views.

This is how you would run adodfcmp if it were views that had to be changed:

adodfcmp odffile=pomrc2.odf userid=apps/apps mode=views changedb=yes