Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Powell, Mark D
Sent: Monday, August 23, 2004 9:43 AM
To: 'oracle-l_at_freelists.org'
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.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Jared.Still_at_radisys.com
Sent: Friday, August 20, 2004 6:22 PM
To: oracle-l_at_freelists.org
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
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Aug 26 2004 - 10:21:11 CDT
![]() |
![]() |