1. Create diretory and verify Data pump




 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;

Post a Comment

0 Comments