Re: How to recover SYSTEM objects

From: Tanel P+APU-der <tanel.poder.003_at_mail.ee>
Date: Sat, 21 Aug 2004 01:20:16 +0300
Message-ID: <014801c48703$df62c3e0$55f823d5@porgand>

Back up your current database.
Restore your last backup and recover it to the point before drop using archivelogs. (You do have a backup and are running in archivelog mode, aren't you?)

Otherwise, report which error you got from imp - it's quite late here, thus it's really hard to guess exactly which problem you've hit.

Tanel.

• Original Message ----- From: +ADw-Nguyen+AD4AOw- +ACI-David M+ACI- +ADw-david.m.nguyen+AEA-xo.com+AD4- To: +ADw-oracle-l+AEA-freelists.org+AD4- Sent: Saturday, August 21, 2004 1:09 AM Subject: How to recover SYSTEM objects

+AD4- 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.

---

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:16:02 CDT