Re: IMPDP and REMAP_TABLESPACE

From: Oliver aka v1k1ng0 <ofabelo_at_gmail.com>
Date: Thu, 17 Sep 2009 18:50:45 +0100
Message-ID: <fdd39f610909171050q19ebd078gae917f697a58df8a_at_mail.gmail.com>



Hello,

2009/9/17 chet justice <chet.justice_at_gmail.com>

>
> The command line looked like this:
>
> c:\temp>impdb cjustice/testing_at_testing dumpfile=prod.dmp
> remap_tablespace=USERS:TABLESPACE_1,USERS_TABLESPACE_2,etc.
>
> I received the following error:
>
> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
> Production
> With the Partitioning, OLAP and Data Mining options
> ORA-39001: invalid argument value
> ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified.
>
> I also tried with semi-colons (;) and spaces as delimiters between the
> multiple tablespaces, each time receiving the error above.
>
> Would someone tell me how to use this particular piece of functionality or
> point me in the right direction?

it would be: remap_tablespace=original_tablespace:target_tablespace. If your target schema is different too, you have to use: remap_schema=original_schema:target_schema. I'm spanish, I'm sorry for my bad english. I hope that you can understand me.

Cheers...

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 17 2009 - 12:50:45 CDT

Original text of this message