Loading external CLOB data
Posted on 2007-10-01
I need to load a 66,2 MB file with CLOB content into an Oracle table. I've created an external table to load the contents of this file.
I'm using the function utl_file.cast_to_raw to convert the contents of the file to hexadecimal format. I'm receiving an ORA-22835 error stating that the size of the datafile exceeds the 4000 byte limit. Does this mean that I need to split the file into 4000 byte chunks in order to load the CLOB content into the database. Or is there a more efficient way to this?