I have one situation again.
My data is like
A90402|I|31-1060|Endowed Chair/Telecom Market|Endowed Chair in Telecommunication Marketing| |EO
And my control file says
INSERT INTO TABLE owbrep.ALLOCATION
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
The problem is with this column "LONG_NAME2".It is not null.It has a space character.But still my sqlldr throws this error
Record 2: Rejected - Error on table OWBREP.ALLOCATION, column LONG_NAME2.
ORA-01400: cannot insert NULL into ("OWBREP"."ALLOCATION"."LONG_NAME2")
Please suggest what needs to be done.How to get rid of this null error as my column has a space character and this is to be loaded into the target table as it is.
I have a scenario where the data file has values separated by ^.While loading this data into the table using sql loader I want to convert it into multiple lines.eg:
1|1013 park ridge~12345~irving|
2|2013 park ridge~12345~irving|
3|1013 park ridge|
while loading it into table i want the data like
1 "1013 park ridge
2 "2013 park ridge
My control file says:
preserve blanks INTO TABLE owbrep.owb_test1
fields terminated by '|' TRAILING NULLCOLS
Please suggest what should I do?