Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

Urgett !! redirected restore of a tablespace

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Raj - 03 Mar 2006 16:50 GMT
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 - 03 Mar 2006 18:54 GMT
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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.