By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Urgett !! redirected restore of a tablespace

P: n/a
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

Mar 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Mar 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.