LOB field occupy a lots of space

matthewlau · #1 (**permalink**) 12-16-03, 06:10

I created a table with CLOB field, after I import 100,000 records into the table, I find that the .LB file for this table is about 100MB in size, but the source file (for CLOB field) is only 9MB in size, and then I do a select on this table, I found that many blanks inside the CLOB field, can I eliminate these blank so that make the LB file as small as possible.

thx.

dmmac · #2 (**permalink**) 12-18-03, 11:39

Did you define a size for the CLOB column during the create of the table?

You can define a size in the table DDL for the CLOB column -- CLOB(10M).

Quote:

Originally posted by matthewlau
I created a table with CLOB field, after I import 100,000 records into the table, I find that the .LB file for this table is about 100MB in size, but the source file (for CLOB field) is only 9MB in size, and then I do a select on this table, I found that many blanks inside the CLOB field, can I eliminate these blank so that make the LB file as small as possible.

thx.

Internet Services

Web Development

Digital Marketing

Consumer Tech