Re: keep dictionary objects

From: <jtesta_at_dmc-it.com>
Date: Thu, 25 Mar 2004 12:11:07 -0500 (EST)
Message-ID: <42049.155.188.255.3.1080234667.squirrel@www.dmc-it.com>

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:26:03 CST