1) I created external table and accessing a file. But I am getting the below error in log file and 3 records got rejected. This is becuse CREATE_DATE_TIME null in the flat file.
error processing column CREATE_DATE_TIME in row 103 for datafile C:\test\ADDRESS_DATA.txt
But when I load through sql loader these three records also getting loaded.
So can you please let me know how can I access there 3 records also even though the create_date_time value is not present in the flat file?
Please find the attached external table creation script file.
2) Also can you please let me know if I can create the Oracle directory referring the network path and access the flat file for the oracle external table?
I tried to give the network path but not able to create oracle directory.
Just wanted to know path problem which I am giving or I cannot create oracle directory for a network path itself.
Can you please suggest for both the questions?