RE: IMPDP and REMAP_TABLESPACE
Date: Thu, 17 Sep 2009 12:53:04 -0500
Message-ID: <565F609E6D736D439837F1A1A797F341020CCD02_at_ADMINMAIL1.ui.uillinois.edu>
I think you want:
Remap_tablespace=USERS:TABLESPACE_1, ADIFFERENTTABLESPACE:TABLESPACE_2, etc etc. You can't remap a tablespace twice.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oliver aka v1k1ng0
Sent: Thursday, September 17, 2009 12:51 PM
To: chet.justice_at_gmail.com
Cc: oracle-l
Subject: Re: IMPDP and REMAP_TABLESPACE
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-lReceived on Thu Sep 17 2009 - 12:53:04 CDT