5. ORA-01841 (full) year must be between -4713 and +9999, and not be 0
Question: I have a table with a column having date as 20150324 i.e YYYYMMDD. When I try to load this data via sqlldr , it gives me the ORA-01841 error
ORA : 01841. ORA-01841: (full) year must be between -4713 and +9999, and not be 0 My SQL*Loader control file looks like this:
admidate date 'YYYYMMDD' NULL IF admidate = BLANKS;
Answer: The oerr utility notes this on the ora-01841 error:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Cause: Illegal year entered
Action: Input year in the specified range
On Oracle MOSC, a case is present concerning ORA-01841. The solution is described as follows and includes some information about ORA-01841 and a few associated bugs. The bBug numbers are 944232 and 935135.