I need to load tab delimited file through loader . I know how to load ',' delimited . In the control file we use fields terminated by "," ,if spaces fields terminated by spaces . Question is How to do for TAB delimited file ..I can't go by position since it is not fixed length record file .. Need help on this ,Thanks in advance ..
Just throwing in my 2 cents. I saved this but I'm unsure where I found it. This may help you also.
December's Tip of the Month
Using SQL*Loader to Load Tab-delimited Files
Tip supplied by: Eva Blinder (firstname.lastname@example.org)
The trick is that the tab delimiter has to be specified in hexadecimal format, and SQL*Loader is very picky about the syntax. Here is an example of the control file you would create to specify a delimiter of tab: