-
By default, sql loader use \n as the line terminator. i.e. as soon as it sees a \n, it treat anything behind it as the new line.
However, one of columns in my output file also has \n inside. This did confuse SQL Loader since it thought that's the end of the line while there are still many columns after that.
So how can get this problem resolved?
I can regenerate the data file, so that file will be a different line terminator (do differentiate from \n). But can I specify the new terminator in the SQL Loader's control file? If yes, how?
I've been looking at different resources, but haven't got any luck. Your help is very much appreciated!
-
If you are on 8i or 9i you can specify your own line terminator, using so-called "Stream Record Format". Example:
load data
infile 'example.dat' "str X'7c0a'"
into table example
fields terminated by ',' optionally enclosed by '"'
(col1 char(5),
col2 char(7))
Check http://otn.oracle.com/docs/products/...ch03.htm#11770
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|