I'm loading a data file with a DATE field using oracle_loader into an external table.
DATE_FORMAT DATE MASK “YYYYMMDD”
The select statement is rejecting all records where the date in the file is ‘00000000’. “error processing column. ORA-01843: not a valid month”
How can I setup external table access parameters to load a NULL date when data in file is blank or all zeros?