Vs: Re: Transfer Data to another tablespace with different name
Date: Wed, 26 Nov 2008 08:58:16 +0200
Message-Id: <s92d0fc9.059@gw00.edita.fi>
Hi!
Maybe I haven't followed whole discussion from this topic but I wan't to suggest...
If you are using 10g... why not using Data pump?
- expdp original data...
- impdp with REMAP_SCHEMA & REMAP_TABLESPACE options to different user (copy)
- If data needs to get to original user then use alter table... move command to copied data and rename objects if needed.
is this usable?
-Teijo L.
Oracle DBA
>>> "Amir Gheibi" <gheibia_at_gmail.com> 26.11.2008 4:20 >>>
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-lReceived on Wed Nov 26 2008 - 00:58:16 CST