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

On Oct 12, 4:55*pm, python <ang... (AT) gmail (DOT) com> wrote:
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

On Oct 13, 7:55*am, python <ang... (AT) gmail (DOT) com> wrote:


Not a good idea to do this even if possible in 10gr2.
There are way too many public views and other objects in the SYSTEM
schema for it to be cloned without unintended consequences.
If all you want is to move app tables from system tablespace and
system ownership to somewhere else, then just expdp/impdp those tables
explicitly, rather than the entire SYSTEM schema.

On Oct 12, 11:49*pm, Noons <wizofo... (AT) gmail (DOT) com> wrote:
It appears that is what he tried to do, note the parfile he used. The
answer may be to use the username/password for expdp as he did for
impdp.

jg
--
@home.com is bogus.
http://www.theage.com.au/travel/pass...927-15u4j.html