RE: How to recover SYSTEM objects
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Aug 2004 14:55:29 -0400
Caveat emptor: They are not always right!
Does your database still run and have not problems? Then just forget
recreating the system user. If not, and it is trashed, try rerunning the
catalog scripts which should not make thing worse or at best create a new
database and import the other users, not sys or system.
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gamble, Scott
Sent: Thursday, August 26, 2004 2:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: How to recover SYSTEM objects
About a month ago we had a fellow DBA accidentally drop the system user. =
Opening a TAR with Oracle the only solution they would give us was to =
restore a backup and recover to a point prior to the drop.
We asked them about doing all kinds of things including the =
export/import from another database or rerunning cat*.sql and they would =
not give us the ok on anything but the restore.
Scott
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ruth Gramolini
Sent: Thursday, August 26, 2004 10:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
