Thanks but this doesn't seem to work if you are not using a data file, i.e only using data generated in the control file, the double quotes start the control file looking for a .dat file-
SQL*Loader-500: Unable to open file (test.dat)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
No, having the data in the control file makes no difference at all. I can use this syntax with inline data with no problems using my Oracle 8.1.7 loader. Here is a sample control file, which is partially derived from the Oracle documentation.
LOAD data
Infile *
append
INTO TABLE Test_date
( date_col "SYSDATE - 1",
col1 POSITION(01:03) CHAR "trimcol1)",
col2 POSITION(04:10) CHAR )
begindata
A 4567890
B 4567890
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.