Re: Transfer Data to another tablespace with different name

From: Yechiel Adar <>
Date: Tue, 25 Nov 2008 19:30:31 +0200
Message-id: <>

This will MOVE the data from the source. He wants to COPY it.

Adar Yechiel
Rechovot, Israel

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 - 11:30:31 CST

Original text of this message