ÃÖ±æÈ£
[LIST]
|
2020-10-07 00:43:23, Á¶È¸ : 381 |

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 [ °ªÀÌ Ãʰú ÇÑ´Ù / Å×À̺í Ä÷³ , °ü·Ã ÆÄÀÏ Á¤º¸ ¼öÁ¤ ]
| 216.73.216.248
|
|