If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

hi
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