Re: Transfer Data to another tablespace with different name
From: William Robertson <william_at_williamrobertson.net>
Date: Sun, 23 Nov 2008 07:54:09 +0000
Message-ID: <49290C21.90402@williamrobertson.net>
Why not just
Then rebuild any indexes on t.
-----Original message-----
From: Amir Gheibi
Date: 23/11/08 05:55
Date: Sun, 23 Nov 2008 07:54:09 +0000
Message-ID: <49290C21.90402@williamrobertson.net>
ALTER TABLE t MOVE TABLESPACE new_tablespace;
Then rebuild any indexes on t.
-----Original message-----
From: Amir Gheibi
Date: 23/11/08 05:55
How can I transfer data from a tablespace in one db to another tablespace in the same db?-- http://www.freelists.org/webpage/oracle-l Received on Sun Nov 23 2008 - 01:54:09 CST
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.