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

preview_player
Показать описание
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:

Рекомендации по теме
Комментарии
Автор

Good Example on Oracle Export / Import

parthparth