EXPDP - SQL PUMP DUMP사용법

#sqlplus / as  sysdba
sql> SELECT * FROM DBA_DIRECTORIES;

sql> CREATE OR REPLACE DIRECTORY DP_DIR AS "경로";
sql> GRANT READ, WRITE ON DIRECTORY DP_DIR TO 사용자;


--DUMP.PAR 작성
SCHEMAS=KCA_RUN
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=kca_run.dmp
LOGFILE=kca_run.log
EXCLUDE=TABLE:"IN ('TZIP_CCW', 'TZIP_CTPV', 'TZIP_EMD', 'TZIP_LNDN', 'TZIP_LNDN_ENTR', 'TZIP_ROAD', 'TZIP_ROAD_ENTR')"

--실행
sql> expdp ID/PW PARFILE=DUMP.PAR