请各位oracle 高手帮小弟看看下面的问题,谢谢!!!!!

Question

问题又有进展:
我把控制文件改了一下,如下:load data
infile 'D:\owen\work\CardAttendence\Completed\Output.txt'
badfile 'D:\owen\work\CardAttendence\Completed\Output.bad'
append
into table system.card_time_original 
WHEN lName != ' '
fields terminated by ","   
( lName,fName,emp_id,year,month,day,hour,minute,second,inOut,status,doorName,dept )
into table system.card_time_original1 
WHEN lName != ' '
fields terminated by ","   
( lName,fName,emp_id,year,month,day,hour,minute,second,inOut,status,doorName,dept )结果出现第一个表中导入了数据,但第二个表中没有数据,日志如下:
SQL*Loader: Release 10.2.0.1.0 - Beta on 星期一 12月 26 11:51:03 2005Copyright (c) 1982, 2005, Oracle.  All rights reserved.Control File:   D:\owen\work\CardAttendence\Completed\input.ctl
Data File:      D:\owen\work\CardAttendence\Completed\Output.txt
  Bad File:     D:\owen\work\CardAttendence\Completed\Output.bad
  Discard File:  none specified
 
 (Allow all discards)Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      ConventionalTable SYSTEM.CARD_TIME_ORIGINAL, loaded when LNAME != 0X20(character ' ')
Insert option in effect for this table: APPEND   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
LNAME                               FIRST     *   ,       CHARACTER            
FNAME                                NEXT     *   ,       CHARACTER            
EMP_ID                               NEXT     *   ,       CHARACTER            
YEAR                                 NEXT     *   ,       CHARACTER            
MONTH                                NEXT     *   ,       CHARACTER            
DAY                                  NEXT     *   ,       CHARACTER            
HOUR                                 NEXT     *   ,       CHARACTER            
MINUTE                               NEXT     *   ,       CHARACTER            
SECOND                               NEXT     *   ,       CHARACTER            
INOUT                                NEXT     *   ,       CHARACTER            
STATUS                               NEXT     *   ,       CHARACTER            
DOORNAME                             NEXT     *   ,       CHARACTER            
DEPT                                 NEXT     *   ,       CHARACTER            Table SYSTEM.CARD_TIME_ORIGINAL1, loaded when LNAME != 0X20(character ' ')
Insert option in effect for this table: APPEND   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
LNAME                                NEXT     *   ,       CHARACTER            
FNAME                                NEXT     *   ,       CHARACTER            
EMP_ID                               NEXT     *   ,       CHARACTER            
YEAR                                 NEXT     *   ,       CHARACTER            
MONTH                                NEXT     *   ,       CHARACTER            
DAY                                  NEXT     *   ,       CHARACTER            
HOUR                                 NEXT     *   ,       CHARACTER            
MINUTE                               NEXT     *   ,       CHARACTER            
SECOND                               NEXT     *   ,       CHARACTER            
INOUT                                NEXT     *   ,       CHARACTER            
STATUS                               NEXT     *   ,       CHARACTER            
DOORNAME                             NEXT     *   ,       CHARACTER            
DEPT                                 NEXT     *   ,       CHARACTER            value used for ROWS parameter changed from 64 to 38Table SYSTEM.CARD_TIME_ORIGINAL:
  47 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Table SYSTEM.CARD_TIME_ORIGINAL1:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  47 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Space allocated for bind array:                 254904 bytes(38 rows)
Read   buffer bytes: 1048576Total logical records skipped:          0
Total logical records read:            47
Total logical records rejected:         0
Total logical records discarded:        0Run began on 星期一 12月 26 11:51:03 2005
Run ended on 星期一 12月 26 11:51:04 2005Elapsed time was:     00:00:01.08
CPU time was:         00:00:00.09

Answer 1

load data
infile 'D:\owen\work\CardAttendence\Completed\Output.txt'
badfile 'D:\owen\work\CardAttendence\Completed\Output.bad'
append
into table system.card_time_original 
WHEN lName != ' '
fields terminated by ","   
( lName,fName,emp_id,year,month,day,hour,minute,second,inOut,status,doorName,dept )
into table system.card_time_original1 
WHEN lName != ' '
fields terminated by ","   
( lName position(1:100) char terminated by "," , fName,emp_id,year,month,day,hour,minute,second,inOut,status,doorName,dept )

Answer 2

这个问题我已经答复过你了，注意那个帖子里面我的最后一个的关键所在：每个数据行的最前面有一个字符 ‘1’控制文件中用到了 FILLER认真看看

Answer 3

请问楼上的兄弟QQ号或者MSN是多少,还有些细节问题想请教请教!!!!