How to remove empty blocks ....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to remove empty blocks ....

  1. #1
    Join Date
    Jun 2002
    Posts
    88

    How to remove empty blocks ....

    Dear Gurus,

    I have one table in my database. Table name is FF_FORMULAS_F.

    SQL> desc ff_formulas_f;
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    FORMULA_ID NOT NULL NUMBER(9)
    EFFECTIVE_START_DATE NOT NULL DATE
    EFFECTIVE_END_DATE NOT NULL DATE
    BUSINESS_GROUP_ID NUMBER(15)
    LEGISLATION_CODE VARCHAR2(30)
    FORMULA_TYPE_ID NOT NULL NUMBER(9)
    FORMULA_NAME NOT NULL VARCHAR2(80)
    DESCRIPTION VARCHAR2(240)
    FORMULA_TEXT LONG
    STICKY_FLAG VARCHAR2(1)
    COMPILE_FLAG VARCHAR2(1)
    LAST_UPDATE_DATE DATE
    LAST_UPDATED_BY NUMBER(15)
    LAST_UPDATE_LOGIN NUMBER(15)
    CREATED_BY NUMBER(15)
    CREATION_DATE DATE

    Now the table i got chaining problem. Already the table one LONG
    column datatype is there. My rdbms version 8.1.7.3

    I thought this is a bug in 8.1.7.3.

    i use following query

    SQL> select owner,table_name,tablespace_name,pct_Free,pct_used,blocks,
    2 empty_blocks,chain_cnt from dba_tables
    3 where table_name = 'FF_FORMULAS_F';

    OWNER TABLE_NAME
    ------------------------------ ------------------------------
    TABLESPACE_NAME PCT_FREE PCT_USED BLOCKS EMPTY_BLOCKS
    ------------------------------ ---------- ---------- ---------- ------------
    CHAIN_CNT
    ----------
    HR FF_FORMULAS_F
    HRD 10 40 25 240
    1

    Empty blocks column shows 240.

    How to remove empty blocks in my table.

    Can u please advise me,

    Thanks in advance,
    Iyyappan.M

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    remove empty blocks....????

    what´s the point? what has that to do with your chaining problem?

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    One chained row in a table - and that is an indication of a problem ????!!!!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    The question you should be asking is how to resolve row chaining, but as has already been pointed out you don't need to worry about that.

    hint : pctused/pctfree
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    hard to avoid chaining with long datatypes, do u really expect that the long datatype column will with into one slot of block?
    I'm stmontgo and I approve of this message

Posting Permissions

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



Click Here to Expand Forum to Full Width