Re: expdp and impd error: ORA-39013

From: ddf <oratune_at_msn.com>
Date: Tue, 12 Oct 2010 21:21:25 -0700 (PDT)
Message-ID: <1b6180e1-dc20-4382-9f94-1051d2abd783_at_w9g2000prc.googlegroups.com>



On Oct 12, 4:55 pm, python <ang..._at_gmail.com> wrote:
> Hi gurus,
>
> Could anyone help me with the impdp utility.
>
> Steps as below
> ===================
> 1) I exported the data using expdp from the SYSTEM user which had few
> application user tables.
>  expdp system/####### parfile=abc_table_list.txt
> dumpfile=abcschema.dmp logfile=abcexplog.log directory=dumpfile
> compression=none
>
> 2)  Copied(scp) the abcschema.dmp to the destination server.
>
> 3) Importing the data into the "abc" schema
> impdp abc/abcabc REMAP_SCHEMA=SYSTEM:ABC  parallel=2
> directory=datapump dumpfile=abcschema.dmp
> logfile=imp_abcuser101110.log
>
> I get this below error
> ORA-39001: invalid argument value
> ORA-39013: Remapping the SYSTEM schema is not supported.
>
> DB Information
> RDBMS Server: 11g R2(11.2.0.1.0)
> OS: rhel5
>
> I was able to do this in Oracle10g R2, but this command doesn't work
> in 11gR2.
> Am I missing something?
>
> Thank you
> RA

Probably. I expect this was unintended behavior in 10gR2 and, as such, has since been corrected. The error message is quite clear and concise.

David Fitzjarrell Received on Tue Oct 12 2010 - 23:21:25 CDT

Original text of this message