PCTFREE = Amount of space to leave in block during insert operations.
Allows room for records to grow within the same area.
PCUSED = The threshold at which the block is placed back on the free block list.
INITIAL/NEXT = The initial disk allocated, and the next extent size.
LOGGING = Indicates whether operations are written to the redo logs.
CREATE TABLE EMPLOYEE (
SALARY NUMBER(8,2) )
INITIAL 200K NEXT 200K
PCTINCREASE 0 MAXEXTENTS 50 )
/* Free table unallocated table blocks */
ALTER TABLE COMPANY DEALLOCATE UNUSED ;