Re: Transfer Data to another tablespace with different name

From: Wolfgang Breitling <>
Date: Mon, 24 Nov 2008 00:55:43 -0700
Message-Id: <>

That should be rather easy:

when you create the structure in the target schema don't create the FK constraints. Then run the import. The import will create and enable the FK constraints after importing the data.

At 10:55 PM 11/22/2008, Amir Gheibi wrote:
>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.


Wolfgang Breitling
Centrex Consulting Corporation

Received on Mon Nov 24 2008 - 01:55:43 CST

Original text of this message