Hello Folks, My woes have deepened the server crashed on me. The server has recovered fine, except that the user dose not exist anymore, however the tablespaces remain "full". I have started to create new tablespaces for data and indexes. Will I be able to restore this users data or will the database still have object names etcetera in the dictionary? This is with the idea of dropping the tablespaces at a later stage. Regards Denham ---------------------------------------------------------------- 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 -----------------------------------------------------------------