sqlldr로 데이타를...입력하려고...합니다..
근데..에러가..나네요....
다른테이블은...잘..넣었는데..이..테이블만..에러가..납니다..
도대체..무슨..문제인지?
화일들의 내용은 아래에 있습니다..
보시구..문제점을...좀...파악해..주세요....
에러는 (invalid column name...)입니다...(근데..제가..다확인했거든요...)
======================================================================
# usertbl.sh의 내용
sqlldr userid=아이디/비밀번호@알리아스 control=usertbl.ctl errors=100000
======================================================================
======================================================================
# usertbl.ctl의 내용
load data
infile './usertbl.dat'
append
into table user_tbl
fields terminated by '|'
trailing nullcols
(
ID char"trim(:ID)",
UMS_ID char"trim(:UMS_ID)",
PASSWD char"trim(:PASSWD)",
MUID char"trim(:MUID)",
MGID char"trim(:MGID)",
QUOTA char"trim(:QUOTA)",
HOME char"trim(:HOME)",
SHELL char"trim(:SHELL)",
ENABLE_SW char"trim(:ENABLW_SW)",
DEL_SW char"trim(:DEL_SW)",
REG_DATE char"trim(:REG_DATE)",
DOMAIN_PATH char"trim(:DOMAIN_PATH)"
)
======================================================================
======================================================================
# usertbl.dat의 내용
themall |themall |duftlal |1000|1000| 20|/baubau/m01/baubau.com/t/h|/bash/false|Y |N |19991123000000|/baubau/m01/baubau.com
broom |broom |dl9672 |1000|1000| 20|/baubau/m01/baubau.com/b/r|/bash/false|Y |N |20000112182831|/baubau/m01/baubau.com
baubau |baubau |hbg28578|1000|1000| 20|/baubau/m01/baubau.com/b/a|/bash/false|Y |N |19991122000000|/baubau/m01/baubau.com
======================================================================
======================================================================
# usertbl.log의 내용
======================================================================
SQL*Loader: Release 8.0.5.1.0 - Production on Thu Nov 9 21:10:50 2000
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Control File: usertbl.ctl
Data File: ./usertbl.dat
Bad File: usertbl.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 100000
Bind array: 64 rows, maximum of 65536 bytes
Continuation: none specified
Path used: Conventional
Table USER_TBL, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * | CHARACTER
UMS_ID NEXT * | CHARACTER
PASSWD NEXT * | CHARACTER
MUID NEXT * | CHARACTER
MGID NEXT * | CHARACTER
QUOTA NEXT * | CHARACTER
HOME NEXT * | CHARACTER
SHELL NEXT * | CHARACTER
ENABLE_SW NEXT * | CHARACTER
DEL_SW NEXT * | CHARACTER
REG_DATE NEXT * | CHARACTER
DOMAIN_PATH NEXT * | CHARACTER
Column ID had SQL string
"trim(:ID)"
applied to it.
Column UMS_ID had SQL string
"trim(:UMS_ID)"
applied to it.
Column PASSWD had SQL string
"trim(:PASSWD)"
applied to it.
Column MUID had SQL string
"trim(:MUID)"
applied to it.
Column MGID had SQL string
"trim(:MGID)"
applied to it.
Column QUOTA had SQL string
"trim(:QUOTA)"
applied to it.
Column HOME had SQL string
"trim(:HOME)"
applied to it.
Column SHELL had SQL string
"trim(:SHELL)"
applied to it.
Column ENABLE_SW had SQL string
"trim(:ENABLW_SW)"
applied to it.
Column DEL_SW had SQL string
"trim(:DEL_SW)"
applied to it.
Column REG_DATE had SQL string
"trim(:REG_DATE)"
applied to it.
Column DOMAIN_PATH had SQL string
"trim(:DOMAIN_PATH)"
applied to it.
SQL*Loader-930: Error parsing insert statement for column USER_TBL.DOMAIN_PATH.
ORA-00904: invalid column name
======================================================================
# DATABASE의 내용
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
HOME_TBL TABLE
REGISTER TABLE
REGISTER_TBL TABLE
SITE_IDX TABLE
SITE_LIST TABLE
SORT_LIST TABLE
USER_TBL TABLE
ZIP_TBL TABLE
8 rows selected.
SQL>
SQL> desc user_tbl;
Name Null? Type
------------------------------- -------- ----
ID NOT NULL CHAR(16)
UMS_ID NOT NULL CHAR(16)
PASSWD NOT NULL CHAR(20)
MUID NUMBER(8)
MGID NUMBER(8)
QUOTA NUMBER(8)
HOME NOT NULL CHAR(64)
SHELL CHAR(16)
ENABLE_SW NOT NULL CHAR(1)
DEL_SW NOT NULL CHAR(1)
REG_DATE NOT NULL CHAR(16)
DOMAIN_PATH NOT NULL CHAR(30)
SQL>
|