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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [68]
02.File Book
File 자료실 [95]
Site Link [16]
개인폴더 [195]
03.Field Book
Altibase [19]
Tibero [29]
MS-SQL [18]
MySQL [38]
DB2 [77]
ORACLE [2762]
PostgreSQL [88]
기타정보 [146]
운영체제 [563]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [1]

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

 회원가입

주소 iloader in [ csv data import ]
최길호 [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


  LIST

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

    목록보기 1
       

Copyright 1999-2021 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
09/25
[ORACLE]
ORA-00600: internal error code....
by 최길호
09/24
[ORACLE]
ORA-24247: network access deni....
by 최길호
07/18
[게시판]
이재명을 지지합니다~ ☜(゚ヮ゚....
by 최길호