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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: keep dictionary objects

Re: keep dictionary objects

From: <thump604_at_comcast.net>
Date: Thu, 25 Mar 2004 17:20:55 +0000
Message-Id: <032520041720.11136.406314F70009590000002B802200734076FFCBCFC98F928A97@comcast.net>


I don't know what all of the tables are and plan on following up on that. That list of tables is just a list that matches a suggested evaluation criteria for determining objects to go in the keep pool and that are owned by sys.

It has always been a suggested practice to pin certain dictionary packages, so this is not much different to me.

--
- David / Thump
Life is what happens while waiting 
or planning for the future.

> 1. This begs to be asked, do you know what those tables are?
>
> 2. Why do you feel the need to change objects owned by sys?
>
> 3. Guess I'm just too anal, the only sys owned object i mess with is aud$
> and then put it back before patching/upgrading.
>
> joe
>
>
> > Has anyone evaluated or have any experience placing any dictionary
> > objects in the keep pool? I'm considering the following for keep pool:
> >
> > SYS ICOL$ 20 TABLE
> > SYS IND$ 19 TABLE
> > SYS CLU$ 5 TABLE
> > SYS C_OBJ# 2 CLUSTER
> > SYS COL$ 21 TABLE
> > SYS TAB$ 4 TABLE
> > SYS COLTYPE$ 241 TABLE
> > SYS ATTRCOL$ 244 TABLE
> > SYS VIEWTRCOL$ 246 TABLE
> > SYS LOB$ 251 TABLE

> > SYS TYPE_MISC$ 253 TABLE
> > SYS NTAB$ 288 TABLE
> > SYS LIBRARY$ 293 TABLE
> > SYS REFCON$ 296 TABLE
> > SYS ICOLDEP$ 299 TABLE
> >
> > --
> > - David
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
>
>
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
Received on Thu Mar 25 2004 - 11:43:17 CST

Original text of this message

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