Re: IMPDP and REMAP_TABLESPACE

From: neil kodner <nkodner_at_gmail.com>
Date: Thu, 17 Sep 2009 13:56:26 -0400
Message-Id: <5D29B2DB-3225-4071-806D-D25886AF56CF_at_gmail.com>

you can have multiple REMAP_TABLESPACE clauses in your par file. you ARE using a par file aren't you? I have a routine expdp/imp where i remap about a dozen prod tablespaces into a single test tablespace.

On Sep 17, 2009, at 1:45 PM, chet justice wrote:

> Database: 10.2.0.3
> DP: 10.2.0.1
>
> I've received a datapump export of our production database (objects
> only) so that I can test my migration script.
>
> On first go, none of the tables were created because the requisite
> tablespaces did not exist in my sandbox.
>
> Via the docs, I found the REMAP_TABLESPACE parameter which seemed to
> suit my needs.
>
> 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?
>
> Thanks
>
> chet
>
> --
> chet justice
> http://oraclenerd.com
> http://twitter.com/oraclenerd

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 17 2009 - 12:56:26 CDT