Re: How to recover SYSTEM objects

  • From: =?utf-7?q?Tanel_P+APU-der?= <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 21 Aug 2004 01:20:16 +0300

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@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: