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