Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump Import remap_Schema does not works

user3636719Mar 15 2013 — edited Mar 15 2013

Hello Gurus,

I am having trouble with import. Even though I specified remap_schema=source:target, import is still doing in source schema.

Here is my export script

nohup expdp "'/ as sysdba'" SCHEMAS=OPS$\SOURCE directory=DATAPUMP dumpfile= SOURCE _03142013.dmp logfile=exp_source.log &

Export is completed without any problem.

Here is my import script

nohup impdp "'/ as sysdba'" remap_schema=OPS$SOURCE:TARGET directory=DATAPUMP dumpfile= SOURCE_03142013.dmp logfile=imp_target.log remap_tablespace=USER_TS:TARGET_DATA_TS &

I tried putting remap_schema= TARGET: OPS$SOURCE, still importing is going on OPS$SOURCE. I followed some threads and granted

grant imp_full_database to target;

Version

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

Please help me with this. Thanks.

This post has been answered by TSharma-0racle on Mar 15 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2013

Added on Mar 15 2013

#database-key-features, #export-import-sql-loader-external-tables

7 comments

1,174 views