All,I just read this thread and i see very useful information. I just want to share my thoughts for PCTUSED Vs PCTFREE for insert only tables.
PCTFREE = 0 AND PCTUSED value does matter for insert only tables. PCTUSED will not play the role as long as we are not deleting any data in the block. Another point here is, we can not set PCTUSED=100 or PCTFREE = 100. The value 100 is invalid value. Also sum of PCTUSED and PCTFREE can not exceed 100. Pease reply if any one is not agreeing. Thanks
SQL> create table test
2 (no number)
3 pctused 0
4 pctfree 100;
ERROR at line 4:
ORA-02211: invalid value for PCTFREE or PCTUSED
SQL> create table test(no number)
2 pctused 60
3 pctfree 41;
create table test(no number)
ERROR at line 1:
ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100
Last edited by pranavgovind; 12-20-2007 at 09:20 AM.