http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: Altibase

 회원가입

주소 iloader in [ csv data import ]
최길호 [LIST]   2020-10-07 00:43:23, 조회 : 270

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.238.125.76


  LIST

제목 작성자 작성일 조회
Admin  dbf 위치 확인 / 삭제 / create database [$ server create MS949 UTF8 ] / 서비스 시작    최길호 2020/10/08 262
Troubleshoot  [FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]    최길호 2020/10/07 343
Admin  주소 iloader in [ csv data import ]    최길호 2020/10/07 270
Admin  altibase replication test    최길호 2016/11/17 1846
Backup & Recovery  hot backup script [ alter database backup database to '/backup/'; ]    최길호 2016/10/02 1181
Admin  -- 모든 테이블    최길호 2016/10/02 1091
Admin  [ERR-110A4 : Backup in progress. Please wait until the current backup is completed.]    최길호 2016/10/02 745
Admin  Sybase IQ 15.2 evaluation software    최길호 2013/08/21 2875
Admin  alter database rename datafile    최길호 2013/07/27 4149
Backup & Recovery  aexport lv:9   최길호 2013/07/22 1346
Admin  alter tablespace ts_disk1 alter datafile '/altibase/6.1/dbs/tbs_disk1_200.dbf' autoextend on next 200m maxsize unlimited;    최길호 2013/04/13 2783
Troubleshoot  [FAILURE] The data file '/altibase/6.1/dbs/SYS_TBS_MEM_DIC-0-0' has an invalid header. lv:9   최길호 2013/04/11 1382
Troubleshoot  oracle to altibase data type 호환     최길호 2013/04/05 2892
Admin  getdata.sql [ 오라클, 알티베이스 마이그레이션 내용 ] lv:9   최길호 2013/04/05 1298
Admin  http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]    최길호 2013/04/04 13604
Admin  altibase 교육 자료 lv:4   최길호 2013/04/03 1496

    목록보기 1
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호