-
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
-
remove empty blocks....????
what´s the point? what has that to do with your chaining problem?
-
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?
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|