URGENT - dropped a schema accidentally
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT - dropped a schema accidentally

  1. #1
    Join Date
    Jul 2000
    Posts
    31
    Hi:

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

    Thanks,

    Una.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width