RESET PASSWORD AFTER REMAP_SCHEMA

When using REMAP_SCHEMA on an impdp, either some set-up or post-impdp work will be needed by a privileged user. 

Given the commands below, there are two options:

expdp hr/hr SCHEMA=HR directory=dpump_dir dumpfile=hr.dmp

impdp system/manager directory=dpump_dir dumpfile=hr.dmp REMAP_SCHEMA=HR:SCOTT

1.  Create the user SCOTT in the target database before executing the impdp.  In this case, the impdp REMAP_SCHEMA command will add objects from the HR schema into the existing SCOTT schema.  In this case you can connect to SCOTT after the impdp without resetting the password.

2.  If the user SCOTT does not exist, impdp will automatically create it with a password, however, you cannot connect to SCOTT on completion of the impdp. A privileged user will need to reset the password for SCOTT on the target database after the impdp completes.