RE: How to recover SYSTEM objects

I may be missing something here, but if the SYSTEM user with it's tables,etc
is created when you create the database couldn't you just create an empty
database and export the SYSTEM schema and import it into the database where
it is lost. If you have another same flavor DB with the SYSTEM schema intact
you could try to use this. If it is created when the cat*.sql scripts are
run you could just rerun them.

Just a thot,
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Powell, Mark D
Sent: Monday, August 23, 2004 9:43 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: How to recover SYSTEM objects


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.

-- Mark D Powell --


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Jared.Still@xxxxxxxxxxx
Sent: Friday, August 20, 2004 6:22 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: How to recover SYSTEM objects


> Someone accidentally drops all SYSTEM objects.  How do we restore
> all objects that belong to SYSTEM?  We have a full export dump file
> but failed to run imp utility to recover.  Please help.
>
Losing the SYSTEM user is not that big a deal.

Just recreate it. You don't actually even need SYSTEM.

Though in 9i+, SYSTEM gets more privileges than are
given by simply granting the DBA role.

Of coures, if SYSTEM owned data objects, you have a problem.

But of course, that was probably not the case.

Jared



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: