Re: How to recover SYSTEM objects

From: <Jared.Still_at_radisys.com>
Date: Fri, 20 Aug 2004 15:21:50 -0700
Message-ID: <OF93AFDC73.71CD2B51-ON88256EF6.007AA039-88256EF6.007ADB9B@radisys.com>

> 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_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 Fri Aug 20 2004 - 17:17:39 CDT