Re: Transfer Data to another tablespace with different name

From: Amir Gheibi <>
Date: Wed, 26 Nov 2008 10:20:30 +0800
Message-ID: <>

Thanks for the reply. My objective is to copy (not move) all the data (including tables) from one tablespace to another. I don't think Exchange Partition does it for me.

On Wed, Nov 26, 2008 at 1:15 AM, Dennis Williams <> wrote:

> Amir,
> Are any of your tables really large? I saw a demonstration years ago where
> EXCHANGE PARTITION was used to change the ownership of a table.
> Basically you can use EXCHANGE PARTITION to switch the ownership. You first
> exchange the table into a partition, then exchange that partition to another
> table owned by another user. Since this is just a dictionary change, there
> is no execution delay. I haven't needed to try this myself, but haven't
> heard this mentioned in awhile.
> Dennis Williams

Received on Tue Nov 25 2008 - 20:20:30 CST

Original text of this message