changing pctfree and pctused

If you change the pctfree and pctused (block utilization parameters) on a table using alter table how does this affect the existing allocated blocks? I have heard two takes. 1) This change only applies to newly allocated blocks. 2) This change applies to all blocks that are touched by Oracle. If number 2 applies, then as I delete data from this table the blocks that are deleted from will get the new pctfree and pctused.

I cannot recreate my table so that all blocks can get the new parameters. It's too big and I can't get the downtime.

Jane Received on Fri Apr 28 2000 - 00:00:00 CDT