How to remove empty blocks ....

[iyyappan]

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

[pando]

remove empty blocks....????

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

[jmodic]

One chained row in a table - and that is an indication of a problem ????!!!!

[Sureshy]

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

[stmontgo]

hard to avoid chaining with long datatypes, do u really expect that the long datatype column will with into one slot of block?