Restore only one table from backup image

grofaty · #1 (**permalink**) 01-25-05, 07:40

Hi,

I have a backup image of database (all tablespaces are in one image). Is it posible to restore only one table from backup image?

My system:
- Windows 2000 sp4
- DB2 v8.1 fp6

Thanks,
Grofaty

sathyaram_s · #2 (**permalink**) 01-25-05, 08:38

I think the answer is, 'You can provided you have enabled dropped table recovery on the tablespaces ...
Read a FAQ in tek-tips.com under the DB2 UDB forum ...

grofaty · #3 (**permalink**) 01-26-05, 01:34

Hi,
Can you please post the link.
Thanks,
Grofaty

grofaty · #4 (**permalink**) 01-26-05, 01:37

Hi,

I have found the tek-tips.com web page.

Thanks a lot,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech