Incomplete recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Incomplete recovery

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi folks,

    Accidentally i happened to drop a table. So
    before doing incomplete recovery i took a full
    database LOGICAL backup to recover the transaction on other tables that occured after the table was dropped.

    Then i did incomplete recovery using UNTIL TIME.

    What should be the IMP statement just to reinsert the rows that were inserted after the table was droppeed.

    When i say ignore=y, the rows get duplicated...but how to just import only the rows of other tables that were added after the table was dropped.

    regards
    sonia


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when you lose a table you dont recover that way, you have to do tablespace point in time recovery

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