Results 1 to 2 of 2

Thread: Recover table

  1. #1
    Join Date
    Sep 2010

    Unanswered: Recover table

    How to recover a table if data is accidentally deleted? We have online database files. The database has 8 tablespaces, we dont want to restore all, just one table. Can we recover one table to another database?

    9.7 fix pack 7.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    If you delete the data, there is not much you can do. If the data is fairly static, you can restore a backup of the database to someplace else and then extract the table data. If it is more dynamic, then the best you can do is suffer some loss.

    If the table is dropped, you might be in better luck: IBM DB2 9.7 Information Center for Linux, UNIX, and Windows


Posting Permissions

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