Re: Oracle 9.2.0.1 Patch to 9.2.0.2

Hemant K Chitale wrote:

> Technically, catpatch.sql doesn't rebuild the Data Dictionary
> but the Data Dictionary Views and [what used to be called in
> the Oracle7 days] the Procedural Option -- ie the PLSQL objects.
> Hemant
>
> DA Morgan wrote:
>
> > > >
> >
> > The catpatch.sql is basically nothing but a rebuild of the data dictionary and
> > related code owned by SYS and SYSTEM. If you don't do it you may find many
> > invalid objects.
> >
> > Daniel Morgan

Here are the three operative parts of catpatch

@@catalog.sql

@@catproc.sql

SELECT dbms_registry.script('JAVAVM','?/javavm/install/jvmpatch.sql') AS file_name FROM DUAL;

You will find the last two do a lot more than dictionary views.

Daniel Morgan Received on Sat Mar 22 2003 - 15:01:57 CST