SQL Loader跑CSV文件 打印日志 没看到有数据跑进去 但是没有报一行错误求解

Question

SQL*Loader: Release 11.2.0.4.0 - Production on Tue Mar 5 15:41:44 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Control File:   /data/file/ifdata/download/wgsiyoudatan/data/邻小区关系/control.ctl
Character Set ZHS16GBK specified for all input.

Data File:      /data/file/ifdata/download/wgsiyoudatan/data/邻小区关系.CSV
  File processing option string: "str X'0D0A'"
  Bad File:     /data/file/ifdata/download/wgsiyoudatan/data/邻小区关系/邻小区关系.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 1
Errors allowed: 999999999
Continuation:    none specified
Path used:      Direct
Silent options: ERRORS
Table LTE_PARA_ADJ_DT_IMP, loaded from every logical record.
Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ENBID                               FIRST     *   ,  O(") CHARACTER            
LOCALID                              NEXT     *   ,  O(") CHARACTER            
ADJ_INDEX                            NEXT     *   ,  O(") CHARACTER            
ADJ_ENB                              NEXT     *   ,  O(") CHARACTER            
ADJ_ID                               NEXT     *   ,  O(") CHARACTER            
ADJ_NETTYPE                          NEXT     *   ,  O(") CHARACTER            
ADJ_LAC                              NEXT     *   ,  O(") CHARACTER            
ADJ_CI                               NEXT     *   ,  O(") CHARACTER            
TFG_40CONFPARA                       NEXT     *   ,  O(") CHARACTER            
DN                                   NEXT     *   ,  O(") CHARACTER            
DATATIME                             NEXT     *   ,  O(") DATE yyyymmdd        

Table LTE_PARA_ADJ_DT_IMP:
  0 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.

Bind array size not used in direct path.
Column array  rows :    5000
Stream buffer bytes:  256000
Read   buffer bytes:2097152000

Total logical records skipped:          1
Total logical records read:             0
Total logical records rejected:         0
Total logical records discarded:        0
Total stream buffers loaded by SQL*Loader main thread:        0
Total stream buffers loaded by SQL*Loader load thread:        0

Run began on Tue Mar 05 15:41:44 2019
Run ended on Tue Mar 05 15:41:44 2019

Elapsed time was:     00:00:00.67
CPU time was:         00:00:00.48
 

Answer 1

附上 CTL文件日志 

 

OPTIONS (DIRECT=TRUE,ERRORS=999999999,SILENT=(ERRORS),DATE_CACHE=4,SKIP=1,READSIZE=2097152000 )
LOAD DATA
CHARACTERSET ZHS16GBK
INFILE '/data/file/ifdata/download/wgsiyoudatan/data/邻小区关系.CSV' "str X'0D0A'"
INTO TABLE lte_para_adj_dt_imp
APPEND
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(ENBID,LOCALID,ADJ_INDEX,ADJ_ENB,ADJ_ID,ADJ_NETTYPE,ADJ_LAC,ADJ_CI,TFG_40CONFPARA,DN,DATATIME DATE "yyyymmdd")