Re: Transfer Data to another tablespace with different name
From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Mon, 24 Nov 2008 14:01:32 -0500
Message-ID: <74f79c6b0811241101x2e7241dfg4f7db7a42a831406@mail.gmail.com>
Date: Mon, 24 Nov 2008 14:01:32 -0500
Message-ID: <74f79c6b0811241101x2e7241dfg4f7db7a42a831406@mail.gmail.com>
In 10gr2 you can use expdp to export the data and impdp with
remap_tablespace and remap_schema to move from one tablespace to another and
schema to schema.
Finn
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 24 2008 - 13:01:32 CST