Re: Transfer Data to another tablespace with different name

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:

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

--
http://www.freelists.org/webpage/oracle-l