Re: IMPDP and REMAP_TABLESPACE
Date: Thu, 17 Sep 2009 13:56:26 -0400
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
> 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?
> chet justice