How to import data into a user when another user with same data exists

Facing ORA-39151 error while trying to import data into a user when there is another user with same tables ??


Answer

impdp user/password DUMPFILE=file_name directory=dir LOGFILE=test.log REMAP_SCHEMA=USERA:USERB TABLE_EXISTS_ACTION=APPEND

USER A is the existing user USER B is the new user