DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    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.


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    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

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