[Oracle] expdp/impdp 명령어

expdp

 

1. 테이블 단위 백업(emp, dept)

expdp name/name@ip:port/sid DIRECTORY=TEST_DUMP dumpfile=backup.dmp tables=emp,dept logfile=backup.log

 

2. 스키마 단위 백업

expdp name/name@ip:port/sid schemas=name DIRECTORY=TEST_DUMP dumpfile=backup.dmp logfile=backup.log

 

3. DB 단위 백업

expdp name/name@ip:port/sid DIRECTORY=TEST_DUMP dumpfile=backup.dmp full=y logfile=backup.log

---

impdp

1. 테이블 단위 복원(emp, dept)

impdp name/name@ip:port/sid DIRECTORY=TEST_DUMP dumpfile=backup.dmp tables=emp,dept logfile=backup.log

2. 스키마 단위 복원

impdp name/name@ip:port/sid schemas=name DIRECTORY=TEST_DUMP dumpfile=backup.dmp logfile=backup.log

3. DB 단위 백업

impdp name/name@ip:port/sid DIRECTORY=TEST_DUMP dumpfile=backup.dmp full=y logfile=backup.log

---

* 디렉토리 조회

SELECT * FROM dba_directories;  

 

* 디렉토리 생성

CREATE or REPLACE directory TEST_DUMP as '/bak/dpdump';

 

* 디렉토리 접근 권한 부여

GRANT read,write ON directory TEST_DUMP to username;