Re: Attach a tablespace to diff instance?

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 13 May 2004 08:09:21 +0200
Message-ID: <6746a0pscedi86ji3fsktsfj7dg2alsmqu@4ax.com>

On Wed, 12 May 2004 22:17:28 GMT, "Bellatlantic" <noone_at_nowhere.com> wrote:

>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.
>

Read up on 'transportable tablespaces' in the export documentation. Feature is available in 8i, so nothing fancy.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu May 13 2004 - 01:09:21 CDT