Re: Attach a tablespace to diff instance?

From: Paul Murphy <pmurphy3_at_twcny.rr.com>
Date: Wed, 12 May 2004 23:48:35 GMT
Message-ID: <nJyoc.182201$M3.138999@twister.nyroc.rr.com>

You can do this with tablespace point in time recovery (TSPITR). Instructions are included in many Oracle 9i books and the free PDFs at http://tahiti.oracle.com

Good luck,
Paul Murphy

"Bellatlantic" <noone_at_nowhere.com> wrote in message news:Ynxoc.28654$vz5.16552_at_nwrdny01.gnilink.net...
> Howdy,
>
> Running Oracle 9.2.0.3 on HP ux 11i
>
> We have a production environment that someone truncated a partition on.
>
> Is there any way to get a backup of the data file (single file) then
attach
> the tablespace/file to our development instance? We are then planning to
> export from there and re-import to production.
>
> Thanks, I am just getting to know some of the fancy features of 9i.
>
> Wayne B.
>
>
Received on Wed May 12 2004 - 18:48:35 CDT