Re: Transfer Data to another tablespace with different name

I want to keep the original copy intact.. I want to make a copy of the tablespace..

On Sun, Nov 23, 2008 at 9:21 PM, Harshan Vasudevan Eppurath < harshan.eppurath_at_capgemini.com> wrote:

> You can always use move command to put data into another tablespace and
> then rename the objects
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org on behalf of Amir Gheibi
> Sent: Sun 11/23/2008 11:25 AM
> To: oracle-l_at_freelists.org
> Subject: Transfer Data to another tablespace with different name
>
>
> Hi
>
> How can I transfer data from a tablespace in one db to another tablespace
> in the same db?
>
> I have Foreign Key and Sequence objects:
> - Apparently when you use IMP and you already have the structure in the
> destination tablespace created, tables are not imported in the right
> sequence in which the FK - PK relationships are respected and you end up
> with a lot of Key violation errors. It imports the tables that have FK
> objects and since it can not find the PK related to the FK, it doesn't
> import the row and raise an error.
> - Sequences should keep their last used values.
>
> Does anyone have a comprehensice sholution that covers everything?
>
> I'm using 10g R2.
>
> Thanks.
> Amir
>
>
>
>
>
>
>
> This message contains information that may be privileged or confidential
> and is the property of the Capgemini Group. It is
> intended only for the person to whom it is addressed. If you are not the
> intended recipient, you are not authorized to
> read, print, retain, copy, disseminate, distribute, or use this message or
> any part thereof. If you receive this message
> in error, please notify the sender immediately and delete all copies of
> this message.
>

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