RE: How to recover SYSTEM objects
- From: "Gamble, Scott" <Scott.Gamble@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Aug 2004 13:12:21 -0500
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
-----------------------------------------------------------------
Other related posts:
