If the table is the only thing in a tablespace then yes, you have to do
a tablespace level restore. That is if you have not dropped the
tablespace, otherwise no. If not, your best bet is to restore the whole
thing to a different database and export and import the data.

-----Original Message-----
From: Maxim Ness
[mailto:db2udbdba-ezmlmshield-x59693331.[Email address protected]
Sent: Tuesday, September 27, 2005 11:43 AM
To: LazyDBA Discussion
Subject: db2 recovery

Hello DBA's,

Is there a way to restore a single table from a full backup over a
database without overwriting the rest of tables?


Thanks !


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page