Re: Transfer Data to another tablespace with different name
- From: "Amir Gheibi" <gheibia@xxxxxxxxx>
- To: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- 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@xxxxxxxxx> 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
>
Other related posts:
