RE: Transfer Data to another tablespace with different name
From: Harshan Vasudevan Eppurath <harshan.eppurath_at_capgemini.com>
Date: Mon, 24 Nov 2008 04:25:37 +0530
Message-ID: <EFB98575DD1E914C8B8E654146956F0F0C1516@HYDEXC07.kanbay.com>
From: Amir Gheibi [mailto:gheibia@gmail.com]
Sent: Sun 11/23/2008 10:20 PM
To: Harshan Vasudevan Eppurath
Cc: oracle-l@freelists.org
Subject: Re: Transfer Data to another tablespace with different name
Date: Mon, 24 Nov 2008 04:25:37 +0530
Message-ID: <EFB98575DD1E914C8B8E654146956F0F0C1516@HYDEXC07.kanbay.com>
Hi Amir,
What you can do is first take export of objects then do the move. Once you rename the objects import the old tables back. Hope that helps.
Regards
Harshan
From: Amir Gheibi [mailto:gheibia@gmail.com]
Sent: Sun 11/23/2008 10:20 PM
To: Harshan Vasudevan Eppurath
Cc: oracle-l@freelists.org
Subject: 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@capgemini.com> wrote:
You can always use move command to put data into another tablespace and then rename the objects
________________________________
From: oracle-l-bounce@freelists.org on behalf of Amir Gheibi
Sent: Sun 11/23/2008 11:25 AM
To: oracle-l@freelists.org
Subject: Transfer Data to another tablespace with different name
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is
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
intended only for the person to whom it is addressed. If you are not the i ntended 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.
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 Received on Sun Nov 23 2008 - 16:55:37 CST