Re: queries on db corruption..

1. only sys is not exported. And yes, your only option to rebuild the entire database. An excellent reason to switch to archivelog and implement proper procedures
2. I didn't ran into corruption for the past 11 years, ie. once I left the Vax-VMS world ;) I'm not sure what kind of system you would need to experience corruption. But then *Rman* can detect corruption, and *Rman* should be used to backup a database in *archivelog*. Those are the best proactive measures you can take. If you don't get any support for that from your management, it is either time to say goodbye or wait until they blame you when disaster strikes, and fire you. Yours to choose!!

-- 
Sybrand Bakker
Senior Oracle DBA