Import Data From One Schema to Another Schema Using Data Pump || REMAP_SCHEMA in Oracle Data Pump

Опубликовано: 05 Октябрь 2024
на канале: Data Science Center

4,072

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