|
최길호
[LIST]
|
2020-10-07 00:43:23, 조회 : 136 |
create tablespace data datafile
'/backup/altibase/data01.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data02.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data03.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data04.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data05.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data06.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data07.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data08.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data09.dbf' size 10m autoextend on next 200m maxsize unlimited,
'/backup/altibase/data10.dbf' size 10m autoextend on next 200m maxsize unlimited;
create user data identified by data default tablespace data;
https://www.epost.go.kr/search/zipcode/newAddressDown.jsp
파일 [ DATA_JUSO.dat 수정 ]
cat > DATA_JUSO.fmt
table JUSO
{
"우편번호" varchar (60);
"우편일련번호" varchar (60);
"시도" varchar (60);
"시도영문" varchar (60);
"시군구" varchar (60);
"시군구영문" varchar (60);
"읍면" varchar (60);
"읍면영문" varchar (60);
"도로명코드" varchar (60);
"도로명" varchar (60);
"도로명영문" varchar (60);
"지하여부" varchar (60);
"건물번호본번" varchar (60);
"건물번호부번" varchar (60);
"건물관리번호" varchar (60);
"다량배달처명" varchar (60);
"시군구용건물명" varchar (60);
"법정동코드" varchar (60);
"법정동명" varchar (60);
"리" varchar (60);
"산여부" varchar (60);
"지번본번" varchar (60);
"읍면동일련번호" varchar (60);
"지번부번" varchar (60);
}
DATA_NLS_USE=MS949
# run_is.sh [ ALL_CRT_TBL.sql ]
isql -s 127.0.0.1 -u data -p data
create table JUSO
(
"우편번호" varchar (60),
"우편일련번호" varchar (60),
"시도" varchar (60),
"시도영문" varchar (60),
"시군구" varchar (60),
"시군구영문" varchar (60),
"읍면" varchar (60),
"읍면영문" varchar (60),
"도로명코드" varchar (60),
"도로명" varchar (60),
"도로명영문" varchar (60),
"지하여부" varchar (60),
"건물번호본번" varchar (60),
"건물번호부번" varchar (60),
"건물관리번호" varchar (60),
"다량배달처명" varchar (60),
"시군구용건물명" varchar (60),
"법정동코드" varchar (60),
"법정동명" varchar (60),
"리" varchar (60),
"산여부" varchar (60),
"지번본번" varchar (60),
"읍면동일련번호" varchar (60),
"지번부번" varchar (60)
)
tablespace data;
# run_il_in.sh
ls *dat | awk -F . '{printf("iloader -s 127.0.0.1 -u data -p data in -f DATA_JUSO.fmt -t \"|\" -d %s.dat -log %s.log -bad %s.bad\n",$1,$1,$1)}'
iloader -s 127.0.0.1 -u data -p data in -f DATA_JUSO.fmt -t "|" -d DATA_JUSO.dat -log DATA_JUSO.log -bad DATA_JUSO.bad
실행 결과
[altibase@localhost bk]$ iloader -s 127.0.0.1 -u data -p data in -f DATA_JUSO.fmt -t "|" -d DATA_JUSO.dat -log DATA_JUSO.log -bad DATA_JUSO.bad
-----------------------------------------------------------------
Altibase Data Load/Download utility.
Release Version 6.1.1.3.4
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION : TCP
DATA_NLS_USE: MS949
.................................................
5000 record load(JUSO)
.................................................
10000 record load(JUSO)
...
...
570000 record load(JUSO)
.................................................
575000 record load(JUSO)
.................................................
580000 record load(JUSO)
.................................................
585000 record load(JUSO)
........
UPLOAD : 48.4120 sec
Load Count : 585837(JUSO)
진행중 에러 [ 컬럼 길이 늘려 주면 된다. ]
more DATA_JUSO.log
TableName : JUSO
Start Time : Wed Oct 7 00:30:23 2020
Record 36 : 135804|001|서울특별시|Seoul|강남구|Gangnam-gu|||116804166689|영동대로3길|Yeongdong-daero 3-gil|0|5|0|1168010300101890
[ERR-9102B : Token value length overflow. Maximum token length=20. Column =도로명영문 Value=Yeongdong-daero 3-gil]
조치> Maximum token length=20 [ 값이 초과 한다 / 테이블 컬럼 , 관련 파일 정보 수정 ]
|
3.236.13.53
|
|
09/25 