I have a large text file that needs to be loaded into Oracle. I'm planning to use SQL*Loader to load it. Following is my command.
sqlldr userid=xxx/xxx@xxx control=test.ctl bad=test.bad data=test.data log=test.log
My control file looks like this
ERRORS = 10000,
PARALLEL = TRUE,
DIRECT = TRUE,
LOAD DATA APPEND INTO TABLE table
FIELDS TERMINATED BY '^A'
TRAILING NULLCOLS (
The result is there were a small number of rows got rejected. I looked at the bad file and all of them are unicode text.
I'm just wondering what I should do in the control file so as to be able to load those unicode data as well.