嗨,我正在尝试将数据从文件加载到Oracle中的表中,但我收到错误ORA-01843:插入日期时不是有效的月份.
文件中的日期保存为27-01-2014
我表格中的格式设置为DATE.
这是控制文件.
load data infile 'file1.csv' append into table my_table fields terminated by ',' TRAILING NULLCOLS (Case_reference, Attempt_Number, Dialled_Number, Date_Called)
谁知道我哪里出错了?
干杯
Oracle可能每个月需要27个,它会抛出这样的错误
尝试在控制文件中提供格式
load data infile 'file1.csv' append into table my_table fields terminated by ',' TRAILING NULLCOLS (Business_function, Case_reference, Sub_sequence, Dialler_Master_Stream , Dialler_Call_Stream, Dialler_Super_Stream, Attempt_Number, Dialled_Number, Date_Called DATE "DD-MM-YYYY")