1. Create diretory and verify
---------------------------
sql> set lines 200;
set pages 50;
col directory_name format a25;
col owner format a15;
col directory_path format a60;
Select * from dba_directories;
--
sql> Create or replace Directory PUMP_BK_DIR as '/u01/app/oracle/datapump_dir';
sql> grant EXP_FULL_DATABASE to sys;
sql> grant IMP_FULL_DATABASE to sys;
sql> grant READ, WRITE ON DIRECTORY PUMP_BK_DIR to sys;
---
sql> Drop directory Directory_name;
0 Comments