대용량 데이터 밀어넣기

테이블 생성

 

CREATE TABLE "RMZZ_POST_DORO" (
    "ZIPCODE" VARCHAR2(10 BYTE) NULL ,
    "DORO" VARCHAR2(50 BYTE) NULL ,
    "SIDO" VARCHAR2(50 BYTE) NULL ,
    "SIKUGN" VARCHAR2(50 BYTE) NULL ,
    "EUP" VARCHAR2(50 BYTE) NULL ,
    "JIHA" VARCHAR2(50 BYTE) NULL ,
    "BONBUN" VARCHAR2(50 BYTE) NULL ,
    "BUBUN" VARCHAR2(50 BYTE) NULL ,
    "DONG" VARCHAR2(50 BYTE) NULL
)
LOGGING
NOCOMPRESS
NOCACHE

;

COMMENT ON TABLE "RMZZ_POST_DORO" IS '우편번호 도로';
COMMENT ON COLUMN "RMZZ_POST_DORO"."ZIPCODE" IS '우편번호';
COMMENT ON COLUMN "RMZZ_POST_DORO"."DORO" IS '도로명';
COMMENT ON COLUMN "RMZZ_POST_DORO"."SIDO" IS '시,도';
COMMENT ON COLUMN "RMZZ_POST_DORO"."SIKUGN" IS '시,군';
COMMENT ON COLUMN "RMZZ_POST_DORO"."EUP" IS '읍';
COMMENT ON COLUMN "RMZZ_POST_DORO"."JIHA" IS '지하';
COMMENT ON COLUMN "RMZZ_POST_DORO"."BONBUN" IS '본번';
COMMENT ON COLUMN "RMZZ_POST_DORO"."BUBUN" IS '부분';
COMMENT ON COLUMN "RMZZ_POST_DORO"."DONG" IS '동';
 

 

 

[post.ctl]

 

load data
infile 'post.csv'
insert into table RMZZ_POST_DORO
fields terminated by ','
(ZIPCODE,DORO,SIDO,DONG,SIKUGN,EUP,JIHA,BONBUN,BUBUN)

 

 

rem post폴더에 있는 3개의 파일을 루트(c:\)디렉토리에 저장후....
rem c프롬포트에서
sqlplus를 빠져나와서 post가 있는 폴더로 이동한 다음 복사해서 붙여넣기..
sqlldr SCOTT/SCOTT1234 control=post.ctl log=post.log bad=post.bad