recover drop table from archive log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: recover drop table from archive log

  1. #1
    Join Date
    Jan 2007
    Posts
    2

    recover drop table from archive log

    Can anybody tell me the complete steps to recover droped table from achive log .

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what version of oracle are you using.

    IN gheneral though, you cant recover a table from an archived log

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    restore to the point just before the drop, export, import.
    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."

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    unless you're on 10 and have flashback configured.
    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."

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    dont need to have flahback configured to recover a dropped table - just look in the recyclebin

  6. #6
    Join Date
    Jan 2007
    Posts
    2
    I am using Oracle 9i (release 2 9.2.0.1.0).
    If drop table is not possible can you tell me how to recover the lost data .e.g. suppose i deleted some of the rows from any table and i want to recover those again from archive log . what is the procedure to recover those data. Please send me the complete steps.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    recover your last good backup and roll forward to th epoint before you dropped

    or do tablespace point in time recovery and then export the table from another instance as Jeff said above.

    But i'd ask your dba for help on this one

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