Import Data From One Schema to Another Schema Using Data Pump || REMAP_SCHEMA in Oracle Data Pump
Channel: Data Science Center
Date: 16/06/2021

Step i: create directory
Enter user-name: sys as sysdba
Enter password:

alter session set container = orclpdb;

CREATE OR REPLACE DIRECTORY HRDATA  AS 'F:\hrdata';

GRANT READ, WRITE ON DIRECTORY HRDATA TO HR;

GRANT READ, WRITE ON DIRECTORY HRDATA TO BILAL;

GRANT DATAPUMP_EXP_FULL_DATABASE TO HR;

GRANT DATAPUMP_IMP_FULL_DATABASE TO BILAL;

GRANT IMPORT FULL DATABASE TO BILAL;

IN Cmd write the following:
expdp hr/hr@orclpdb tables= emp, dept, loc  DIRECTORY = hrdata dumpfile =  hrdata.dmp logfile= hrdata_log.log

impdp bilal/bilal@orclpdb directory= hrdata dumpfile= hrdata.dmp  REMAP_SCHEMA = HR:BILAL