Clob in oracle 10g
The number doesn't actually limit the CLOB, but you're probably right to worry about the metadata being different on your servers. You might want to run area907.info_DDL on the objects on all servers and compare the results. I was able to create a low data_length by adding a CLOB . Feb 01, · Hi, Can any one tell me how to convert a CLOB into BLOB? In Oracle 10g there is a function which is converttoblob(). In Oracle 10g there is a function which is converttoblob(). But in Oracle 9i there is no function as such. In Oracle 10g, the CLOB datatype can store up to (4GB-1)*(the value of the CHUNK parameter). If the CHUNK parameter is not explicitly set, the CLOB datatype can store up to (4GB-1)*(database block size). In Oracle 8i and 9i, the CLOB datatype is restricted to 4GB in size. The above can all be verified in the SQL Reference manual under Datatypes.