Hello folks.


I am currently on a system using Oracle 9i. We don't have RMAN setup, and im curious as to what exactly Im going to have to do to perform an import/export to fully backup and restore a schema.

Ive been doing my exp with FULL=Y DIRECT=Y CONSISTENT=Y

what is NOT included for a schema in this export? Users/roles/etc??

If I have a backup from say 5 minutes ago and I want to completely reload the dmp file, what do I have to drop first, just the tables, or can I blow away the entire schema/tablespace and reload from the dmp?