Urgett !! redirected restore of a tablespace

[Raj]

How can we restore a tablespace from a Full backup to a new tablespace
with out effecting the existing tablespace.. (can we use the redirect
option in the backup command for tablespace recovery ???)

Thanks,
Raj

[Pierre Saint-Jacques]

I'm trying to understand what you are trying to do ? However

You can restore a single tablespace from a full db backup image but not
redirect in the database that the inage came from so that you could "see"
two tablespaces (one existing and the same redirected). If you redirect in
the same db the table and data of the existing tablespace will not be
accessible as the tblspce has been restored elsewhere.
The best you could do is to restore fom the image in your test database.
Extract (export, db2move) the data out of that and then move those tables
into a new tablespace on the target db.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Raj" <sp****@yahoo.com> a écrit dans le message de news:
11**********************@u72g2000cwu.googlegroups. com...

How can we restore a tablespace from a Full backup to a new tablespace
with out effecting the existing tablespace.. (can we use the redirect
option in the backup command for tablespace recovery ???)

Thanks,
Raj