| SQL Loader CLOB fields in data [message #140560] |
Tue, 04 October 2005 14:23 |
cumin
Messages: 82
Registered: August 2005
|
Member |
|
|
I am reading bar-delimited fields into a table using sqlldr. Some of the fields are > 6000 chars long; record might look like:
a123|coded897|...a...really..long...7000...char...string...|z-989j
The documentation for loading CLOB data that I have read seems to imply that the CLOB data is in a different file from the non-CLOB data. In my case, I truncated the long fields before loading the data, but I would rather keep all the data.
How do I indicate in the .ctl file that one of the fields in a file is CLOB, and the others are just ordinary CHAR or NUMBER EXTERNAL?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
