Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: LOB field occupy a lots of space

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Massachusetts, USA
    Posts
    106

    Re: LOB field occupy a lots of space

    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).


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •