Re: How to recover SYSTEM objects

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Mon, 23 Aug 2004 13:07:03 -0600
Message-id: <412A4057.4070102@sun.com>

The thought that nags me about this is that 'SYSTEM objects' has several meanings. There are objects owned by the user SYSTEM. There are objects required for core database functionality, which I have seen referred to as system objects.

My first reading of the original email made me think of the former. A second reading made me think of the latter. A third reading made me think of a good glass of single malt. See you all later...

Daniel Fink

Jared.Still_at_radisys.com wrote:

>>Jared, the user id SYSTEM is almost always an object owner since a fresh
>>Oracle install will create numerous objects under SYSTEM at least under
>>versions 8.0 - 9.2.  Maybe Oracle cleaned this up with version 10 but I 

>
> see
>

>>junk related to materialized views and replication neither of which we 

>
> use
>

>>just after database creation.
>>

>
> Argh, I should have checked before I replied.
>
> I was working on 7.3 knowledge I'm afraid.
>
> There are a number of system objects that are owned by the SYSTEM account.
>
> Though it should be possible to recreate SYSTEM, as I
> *think* they are all static objects.
>
> Jared

---

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 Mon Aug 23 2004 - 14:03:56 CDT