Oracle sqlload : split a source field in several columns?

i have a source file i want to load through sqlload in my Oracle 10g

开发者_开发百科the problem is one of the source field can be larger than 4000 character. Is it possible to tell oracle to split a source field in several columns ?

let's say one column would have 4000 first character and the second one the 4000 next

Thanks

I'd load it into a CLOB and then do the splitting (if necessary) using DBMS_LOB.SUBSTR over on the database side. But is there a critical business reason to get it into multiple varchar2 columns, or could it just stay in the CLOB?