ORACLE DATAPUMP설정(WINDOWS 서버)

DATAPUMP 설정 후 IMPDP 하는 방법

 

 

1)     D:data\datapump 디렉토리 생성

2)     Create directory datapump as ‘d:\data\datapump’;

3)     Grant read, write on directory datapump to 유저;

4)     Grant create any directory to 유저;

 

5)     ImpDP 실행

impdp system/xxxx directory=datapump dumpfile=backup.dmp logfile=backup.log full=y