Ron,

It depends on how you build the database.
If you use the clone method, the base database provided
from oracle is not upgraded when patching.
That is, base install 9201, patch to 9207, the base database
used by dbca is still 9201, and must be catpatch'ed.

If you use dbca to create scripts, then run in the scripts manually,
I believe (haven't tested this myself directly) that you will then
wind up with a 9207 database directly.

HTH,
Matt

On Tue, 2005-11-29 at 08:45 -0600, Smith Ron wrote:

> I have installed Oracle 9.2.7 on a Sun box.
> When I create a new database with DBCA everything goes well until I do
> an export.
> The export fails due to a metadata error.
>
> The only way I have found to fix the problem is to run catpatch every
> time I create a new database.
>
> Seems to me, once the patch has been applied to the RDBMS libraries I
> should not have to run catpatch again.
>
> Am I missing something?
>
> Thanks!
> Ron
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html

----------------------------------------------------------------
|Matthew W. Ball (Matt)
|Team Lead for Infrastructure and Reliability Group
|Endeavor Information Systems Inc.
|(e) [Email address protected]
|(p) 847-227-2678
|(f) 208-275-0869
|(u) http://www.endinfosys.com
--------------------------------------------------------------
#define THE_QUESTION
(( (bb) || ! (bb) ))
- W. Shakespeare
--------------------------------------------------------------

Oracle LazyDBA home page