[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3202]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
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, Á¶È¸ : 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


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  dbf À§Ä¡ È®ÀÎ / »èÁ¦ / create database [$ server create MS949 UTF8 ] / ¼­ºñ½º ½ÃÀÛ    ÃÖ±æÈ£ 2020/10/08 414
Troubleshoot  [FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]    ÃÖ±æÈ£ 2020/10/07 503
Admin  ÁÖ¼Ò iloader in [ csv data import ]    ÃÖ±æÈ£ 2020/10/07 381
Admin  altibase replication test    ÃÖ±æÈ£ 2016/11/17 2103
Backup & Recovery  hot backup script [ alter database backup database to '/backup/'; ]    ÃÖ±æÈ£ 2016/10/02 1322
Admin  -- ¸ðµç Å×ÀÌºí    ÃÖ±æÈ£ 2016/10/02 4327
Admin  [ERR-110A4 : Backup in progress. Please wait until the current backup is completed.]    ÃÖ±æÈ£ 2016/10/02 822
Admin  Sybase IQ 15.2 evaluation software    ÃÖ±æÈ£ 2013/08/21 2976
Admin  alter database rename datafile    ÃÖ±æÈ£ 2013/07/27 4250
Backup & Recovery  aexport lv:9   ÃÖ±æÈ£ 2013/07/22 1418
Admin  alter tablespace ts_disk1 alter datafile '/altibase/6.1/dbs/tbs_disk1_200.dbf' autoextend on next 200m maxsize unlimited;    ÃÖ±æÈ£ 2013/04/13 2877
Troubleshoot  [FAILURE] The data file '/altibase/6.1/dbs/SYS_TBS_MEM_DIC-0-0' has an invalid header. lv:9   ÃÖ±æÈ£ 2013/04/11 1459
Troubleshoot  oracle to altibase data type ȣȯ     ÃÖ±æÈ£ 2013/04/05 2994
Admin  getdata.sql [ ¿À¶óŬ, ¾ËƼº£À̽º ¸¶À̱׷¹ÀÌ¼Ç ³»¿ë ] lv:9   ÃÖ±æÈ£ 2013/04/05 1378
Admin  http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]    ÃÖ±æÈ£ 2013/04/04 13729
Admin  altibase ±³À° ÀÚ·á lv:4   ÃÖ±æÈ£ 2013/04/03 1581

    ¸ñ·Ïº¸±â 1
       

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
ÃÖ±Ù °Ô½Ã¹°
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£
07/01
[±âŸÁ¤º¸]
shell for 001 ~ 100.
by ÃÖ±æÈ£
06/27
[ORACLE]
The clock on host node2 differ....
by ÃÖ±æÈ£