SQL*LOADER 사용법

작업파일.ctl

LOAD DATA
INFILE '/oradata/juso/00.txt'
INFILE '/oradata/juso/01.txt'
INFILE '/oradata/juso/02.txt'
INFILE '/oradata/juso/03.txt'
INFILE '/oradata/juso/04.txt'
INFILE '/oradata/juso/05.txt'
INFILE '/oradata/juso/06.txt'
INFILE '/oradata/juso/07.txt'
INFILE '/oradata/juso/08.txt'
INFILE '/oradata/juso/09.txt'
INFILE '/oradata/juso/10.txt'
INFILE '/oradata/juso/11.txt'
INFILE '/oradata/juso/12.txt'
INFILE '/oradata/juso/13.txt'
INFILE '/oradata/juso/14.txt'
INFILE '/oradata/juso/15.txt'
INFILE '/oradata/juso/16.txt'
APPEND
INTO TABLE TZIP_LNDN_ENTR
#컬럼 Mapping
FIELDS TERMINATED BY '|'
(STTT_DONG_CODE, CTPV_NM, CCW_NM, STTT_EMD_NM, STTT_RI_NM, MNT_TYPE, LNDN_MAIN_NO, LNDN_SUB_NO, ROAD_NM_CODE, ROAD_NM, UDGR_TYPE, BULD_MAIN_NO, BULD_SUB_NO, BULD_NM, DTL_BULD_NM, BULD_MNG_NO, EMD_SRL_NO, ADTV_DONG_CODE, ADTV_DONG_NM, ZPCD, ZPCD_SRL_NO, MASS_TDST_NM, MVNT_RSN_CODE, CHNG_DATE, CHNG_BF_ROAD_NM_ADDR, CCW_BULD_NM, CLBR_HOUSE_TYPE)



SQL>sqlldr ID/PW control="작업파일.ctl"