How to use REMAP_TABLE parameter in impdp utility
Like you want to import a table from your existing logical backup (export table), but when you checked your database you saw that table is already exist in your database which is created by another user.

So in this situation, how to import that table because it’s import for you, so you can make a duplicate copy of the table using REMAP_TABLE parameter.

So command of importing table will remain the same as previous, we just use REMAP_TABLE parameter in the command.

$impdp scott/tiger directory=dir dumpfile=emp.dmp logfile=emp.log tables=emp remap_table=scott.emp:emp_copy

NOTE:- The REMAP_TABLE parameter use two values, the old name of the table along with user name (schema name like scott.emp) and second is the new name of the table which’s specify by you, both the names are separated by colons.

So after execution of this command you will get a new table in your database which is the duplicate table.