RE: Table belongs to Original tablespace after export with DataPump
Date: Mon, 9 Feb 2009 16:49:45 -0000
Message-ID: <787DD2F284E39D4FA3C2ABD2DAF1AB2DA0FB_at_MAIL.vishalgupta.co.uk>
You can use both remap_schema and remap_tablespace in the same command. We have a batch which uses this on a daily basis.
Regards,
Vishal Gupta
http://www.vishalgupta.com
From: oracle-l-bounce_at_freelists.org on behalf of Niall Litchfield
Sent: Fri 30/01/2009 09:30
To: gheibia_at_gmail.com; ORACLE-L
Subject: Re: Table belongs to Original tablespace after export with DataPump
Hi i'd take a look at the docs. I suspect that you can't use both remap options in the same command. Though clearly that's a fairly obvious use case.
On 1/29/09, Amir Gheibi <gheibia_at_gmail.com> wrote:
> Hi listers,
> I have a 10g DB on HP-UX. I used data pump to make a copy of one of the
> tablespaces. So I exported from one and imported into another one:
>
> $ expdp user1/pass1 schemas=user1 directory=dump_dir
> dumpfile=exp.dmp logfile=expLog.log
>
> $ impdp user2/pass2 directory=dump_dir dumpfile=exp.dmp
> logfile=impLog.log REMAP_SCHEMA=user1:user2
> REMAP_TABLESPACE=tblspc1:tblspc2
>
>
> User1's default tablespace is tblspc1 and User2's default tablespace is
> tblspc2.
>
> What happens is that the "tablespace" property of the imported tables owned
> by "User2" don't change as they are just pointing back to the original
> tables in "tblspc1". Are'nt the imported tables supposed to be copied to the
> destination tablespace?
>
> I logged in as "User2" and ran:
>
> $ select table_name, tablespace_name from user_tables where table_name =
> 'MYTBL'
>
> TABLE_NAME TABLESPACE_NAME
> ---------------------------------------------------------
> MYTBL tblspc1
>
>
> Shouldn't the tablespace_name be "tblspc2"? I thought the data pump creates
> the table in the destination tablespace and then import the data into it.
> How should I prevent that problem at the import time?
>
> Regards,
> Amir Gheibi
>
-- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 09 2009 - 10:49:45 CST