| Trouble loading large fields with Sql Loader [message #73932] |
Wed, 04 August 2004 07:45 |
Miguel Jimeno
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Hi. I want to load a large field using sql loader (In Oracle 8i, 8.1.7). This field contains up to 30K, so I use in the database a "long" field. But, when I try to load it using char(40000) in the control file, then I get some errors. Sometimes, the sqlldr get stuck in a loop (I guess) and it does not load anything, or sometimes the sqlldr stores hexadecimals in the database fields. I'm really stuck here. I've tried using clob and long field in database, and I've tried using char(40000), char, and log varraw in the control file, whar could I be doing wrong??
Thanx, M
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
