Re: Transfer Data to another tablespace with different name
Date: Wed, 26 Nov 2008 10:20:30 +0800
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 < oracledba.williams_at_gmail.com> wrote:
> 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