[oracle@localhost oracle]$ sqlldr userid=scott/tiger@poco1 control=/home/dontgo/html/juni/imsi.ctl
SQL*Loader: Release 8.1.5.0.1 - Production on Sat Aug 19 13:11:08 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-522: lfiopn failed for file (/home/dontgo/html/juni/imsi.bad)
위에처럼 에러가 나는데요... 멀 어케 해야하는건지.....
ctl 화일은
load data
infile '/home/dontgo/html/juni/imsi.txt'
into table stock_d
( code_date position (01:14) char,
start_value position (15:26) integer external,
high_value position (27:38) integer external,
low_value position (39:50) integer external,
end_value position (51:62) integer external,
amount position (63:74) integer external,
updown position (75:86) integer external,
checkt position (87:88) integer external,
name position (89:118) char )
요거 구요...
txt 화일은
46930_2000081812000 12000 12000 12000 107370 2000 1 타임
46810_200008183000 3000 3000 3000 123106 700 1 KEPS
이런게 들어있답니다...
방법좀 갈켜주세요...
|