Re: Transfer Data to another tablespace with different name
Date: Tue, 25 Nov 2008 19:30:31 +0200
This will MOVE the data from the source. He wants to COPY it.
Dennis Williams 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