Re: IMPDP and REMAP_TABLESPACE
- From: chet justice <chet.justice@xxxxxxxxx>
- To: neil kodner <nkodner@xxxxxxxxx>
- Date: Thu, 17 Sep 2009 14:43:49 -0400
Thanks to everyone for their super-fast replies. I was overwhelmed.
Mr. (Tom) Roach cheated though, he called and then IM'd me the answer.
Essentially, I had it backwards.
remap_tablespace=USERS:TABLESPACE_1,USERS_TABLESPACE_2,etc.
should have been:
remap_tablespace=TABLESPACE_1:USERS,TABLESPACE_2:USERS,TABLESPACE_3:USERS
What I didn't explain and Neil alluded to, is that I was trying to map all
of the production tablespaces to a single USERS tablespace (it's a sandbox,
don't give me a hard time ;).
Thanks again.
chet
On Thu, Sep 17, 2009 at 1:56 PM, neil kodner <nkodner@xxxxxxxxx> wrote:
> 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<http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#sthref342>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 -
> 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
>
>
>
--
chet justice
http://oraclenerd.com
http://twitter.com/oraclenerd
Other related posts:
