expdp and impd error: ORA-39013

From: python <angani_at_gmail.com>
Date: Tue, 12 Oct 2010 13:55:34 -0700 (PDT)
Message-ID: <1b849ef5-ee61-4646-b110-491cddb1efed_at_t8g2000yqk.googlegroups.com>



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 Received on Tue Oct 12 2010 - 15:55:34 CDT

Original text of this message