We are facing this issue while trying to load data onto External table using sqlldr- Database version is 12.1.2. Tried to increase the date_cache to 5000, but did not work then as per the oracle document set the value to 0, but, still not working ...
Table definition :
CREATE TABLE MY_TABLE
:::::::::::::::::::
:::::::::::::::::
organization external
(
type ORACLE_LOADER
RECORDS DELIMITED BY NEWLINE
CHARACTERSET CL8ISO8859P5
STRING SIZES ARE IN CHARACTERS
date_cache 0
:::::::::::::::::::::::::::::::
:::::::::::::::::::::::::::::
getting the following error:
---------------------
:::::::::::::::::::::::::::::
:::::::::::::
AUXAC14 CHAR (20)
Date datatype DATE, date mask YYYYMMDD
Terminated by ";"
Enclosed by """ and """
Trim whitespace same as SQL Loader
Date Cache Statistics for table my_table
Date conversion cache disabled due to overflow (default size: 1000)
-------------------------------