DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Mesa, Arizona

    Table recovery question

    I need to recover a single table that was dropped last week.

    The (on RedHat) database is in archivelogmode and a full database backup is done every Sat. Every other night I do archivelog backups.

    My problem is that the tablespace the table was in is online and in use. So I can't just recover the tablespace.

    Is my only option to recover that tablespace to a new database? I'd really like to recover that table alone and to the existing database.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Nov 2000

    Re: Table recovery question

    Originally posted by KenEwald
    I'd really like to recover that table alone and to the existing database.
    I'll bet you would. Unfortunately, the only way I see you can do it is to restore the relavent files & tablespaces (control, system, undo, your ts, etc) on another box, recover to just before the object was dropped, and export/import.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.