Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9.2.0.1 Patch to 9.2.0.2

Re: Oracle 9.2.0.1 Patch to 9.2.0.2

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Sat, 22 Mar 2003 14:52:00 +0800
Message-ID: <3E7C0810.4A8B7F1D@singnet_nospam.com.sg> 






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

Received on Sat Mar 22 2003 - 00:52:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US