Oracle SQL load question
Posted on 2014-09-29
I need to upload a datafile to an Oracle database via SQL load process. It is a working system but the SQL load process stopped working.
The control file of the SQL load process looks like the following:
INTO TABLE rnt.incidents
FIELDS TERMINATED BY x'1'
And the datafile one record is like:
2014-09-07 00:00:17 2014-09-07 00:00:17 Operations 140907-013931 \N \N \N
could anyone assist me to understand what the expected delimited in the datafile is, given the control file content of "FIELDS TERMINATED BY x'1'" .. ?
Thanks a lot.