控制文件内容如下;
LOAD DATA INFILE 'F_DEP_SAE_EVT.txt'
BADFILE 'F_DEP_SAE_EVT.bad'
TRUNCATE INTO TABLE F_DEP_SAE_EVT
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
ODS_1ST_LEV_BR_NO NULLIF ODS_1ST_LEV_BR_NO='\\N',
ODS_SRC_DT NULLIF ODS_SRC_DT='\\N',
CCBS_ACCT_NO NULLIF CCBS_ACCT_NO='\\N',
CUST_ACCT_NO NULLIF CUST_ACCT_NO='\\N' ,
SA_CUST_NO NULLIF SA_CUST_NO='\\N' ,
ECIF_CUST_NO NULLIF ECIF_CUST_NO='\\N' ,
SA_ACCD_COD NULLIF SA_ACCD_COD='\\N' ,
SA_ACCD_DT NULLIF SA_ACCD_DT='\\N' ,
SA_EVT_SRL_NO NULLIF SA_EVT_SRL_NO='\\N' ,
SA_ACCD_TM NULLIF SA_ACCD_TM='\\N' ,
SA_CURR_COD NULLIF SA_CURR_COD='\\N' ,
SA_OPR_NO NULLIF SA_OPR_NO='\\N' ,
SA_CURR_IDEN NULLIF SA_CURR_IDEN='\\N' ,
SA_ACCD_RMRK NULLIF SA_ACCD_RMRK='\\N' ,
STD_OPUN_COD NULLIF STD_OPUN_COD='\\N' ,
SA_ACCD_INSTN_NO NULLIF SA_ACCD_INSTN_NO='\\N' ,
SA_ACCD_AMT NULLIF SA_ACCD_AMT='\\N' ,
SA_CRET_ID NULLIF SA_CRET_ID='\\N' ,
SA_CRET_TYP NULLIF SA_CRET_TYP='\\N' ,
SA_PROCESS_FLAG NULLIF SA_PROCESS_FLAG='\\N' ,
SA_PRO_EVT_SRL_NO_N,
SA_UNLCK_DT Date 'yyyy-mm-dd hh24:mi:ss' NULLIF SA_UNLCK_DT='\\N' ,
ODS_SRC_SYS_NO NULLIF ODS_SRC_SYS_NO='\\N' ,
ODS_LOAD_DT NULLIF ODS_LOAD_DT='\\N'
)
文本文件里面内容如下:
460|*|4600026361011200026360033550|46001002636050033550|*|*|2120|2005-03-25|1| |156|460002636DDD|0| |*|460002636|30000000.0| | |N|0| |*|*|
460|*|4600020361011100020360006504|46001002036050006504|*|*|8110|2002-09-17|1| |156|460002036DDD|0| |*|460002036|1463.84| | |N|0| |*|*|
460|*|4600031361012300031360002006|46001003136050002006|*|*|8110|2002-11-20|1| |156|460003136DDD|0| |*|460003136|1863.18| | |N|0| |*|*|
460|*|4600042361014400042360001950|46001004236050001950|*|*|2110|2005-04-07|1| |156|460004236DDD|0| |*|460004236|126000.0| | |N|0| |*|*|
460|*|4600025361014500025360005001|46001002536050005001|*|*|8110|2001-07-31|1| |156|460002536DDD|0| |*|460002536|106.29| | |N|0| |*|*|
460|*|4600036361015200036360009950|46001003636050009950|*|*|2120|2003-01-16|1| |156|460003636DDD|0| |*|460003636|10.17| | |N|0| |*|*|
460|*|4600024361014700024360006252|46001002436050006252|*|*|8110|2002-03-25|1| |156|460002436DDD|0| |*|460002436|146.07| | |N|0| |*|*|
460|*|4600021361014800021360008208|46001002136050008208|*|*|2110|2004-11-12|1| |156|460002136DDD|0| |*|460002136|200000.0| | |N|0| |*|*|
460|*|4600057361017200057360005707|46001005736050005707|*|*|2120|2004-09-06|1| |156|460005736DDD|0| |*|460005736|113.48| | |N|0| |*|*|
460|*|4600034361034200034360001558|46001003436050001558|*|*|2120|2005-03-18|1| |156|460003436DDD|0| |*|460003436|176.11| | |N|0| |*|*|
460|*|4600036361084200036360002653|46001003636050002653|*|*|8110|2004-10-12|1| |156|460003636DDD|0| |*|460003636|18614.8| | |N|0| |*|*|
460|*|4600061361094200061360001803|46001006136050001803|*|*|8110|2001-12-30|1| |156|460006136DDD|0| |*|460006136|2.26| | |N|0| |*|*|
460|*|4600063361094200063360001008|46001006336050001008|*|*|8110|2002-07-18|1| |156|460006336DDD|0| |*|460006336|515.84| | |N|0| |*|*|
倒数第三个字段为时间字段,但文本文件内容为空,所以在导入时,报一下错误:
Record 3: Rejected - Error on table F_DEP_SAE_EVT, column SA_UNLCK_DT.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
表结构中这个时间字段可以为空的
请问怎么样把这些时间字段为空的数据导进去