I need help urgently. I accidentally dropped and recreated a schema and the users want the old objects (tables, triggers, sequences etc) back. I am running the database in archive mode with hot backups....
Please help with a sequence of steps to take...
1. restore last hot backup to another location (machine, directory structure, etc).
2. recover database to the point right before you dropped the user.
3. export user
4. import user into old database
you have to restore your backup in another directory or another machine (if same machine remember change ORACLE_SID), in other words clone the database, and apply recovery until the point before you drop the schema, then export the schema and import into your database (not the cloned database, the one needs the schema).
If you have recent exports of schema or whole database and yu dont mind losing some data then just import from your recent export
Click Here to Expand Forum to Full Width