Dear PAVB,

Thanks for your reply. Sorry I have typo on my impdp command, it should be the same dump file. the command for expdp and impdp are:

From produciton dba:
expdp / directory=PROD_DP_DIR dumpfile=prod_ref.dmp schemas=state,scott,employee parallel=2

From development db:
impdp / directory=DEV_DP_DIR dumpfile=prod_ref.dmp schemas=state,scott,employee logfile=dev.log parallel=2

Any advice?


Thanks,
Unna