Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: keep dictionary objects
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.Received on Thu Mar 25 2004 - 11:43:17 CST
> 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 -----------------------------------------------------------------
![]() |
![]() |