|
Explanation: When more than one extent is allocated to a database table on creation, chances are the table was created with MINEXTENTS set to a value greater than one in the STORAGE clause when the object was created. Oracle would never create a database table with more than one extent by default. The values for PCTINCREASE and MAXEXTENTS setting indicate storage settings that have no bearing on the initial number of extents allocated to a table, so they are both incorrect as well. Reference: Oracle 9i: Administrator’s Guide Oracle 9i: Concepts
|