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