Hi
I am trying to load a csv file which also contains a timestamp column into a table using SQL loader. I am getting ORA-26041 error while trying to load the column
Following are the setting in the database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string
nls_language string AMERICAN
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
select sysdate from dual;
SYSDATE
---------
16-NOV-20
The data for the timestamp column in the csv is of the following format
20-Dec-2019 12.51.24.000 PM
I tried the following , but get the same error
export NLS_TIMESTAMP_FORMAT='DD-MON-YYYY HH.MI.SS.FF'