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.1I'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@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 - ProductionWith 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
