Database Utilities (MOSC)

MOSC Banner

impdp help on remap_schema ...............

edited Oct 27, 2010 8:10AM in Database Utilities (MOSC) 5 commentsAnswered ✓
hi , 

in an import datapump test  , I've mentioned as 

1, expdp system/password dumpfile=dpdir:exp.dmp logfile=dpdir:exp.log full=y  (evrey night backup)

2. impdp system/password dumpfile=dpdir:exp.dmp logfile=dpdir:imp.log 
  remap_schema=hrd1:hrdd 

it worked fine , but 

in the logfile  it  is all about the other objects already exist 
in the database and skipped them .   

my question is why it is trying to import all objects from all schema and giving ORA-31684.

here are 2 lines of log .........

ORA-31684: Object type USER:"OUTLN" already exists 
ORA-31684: Object type TYPE:"SYSMAN"."SMP_EMD_STRING_ARRAY_ARRAY" 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center