Lets you indicate the size in Kbytes of the first and/or the following extension(s) assigned to the table or index.
Number of KBytes assigned to the first (and/or following) extension(s) as it expands.
| DBMS |
Use |
Usage |
| Oracle |
First extension |
NEXT parameter for the STORAGE clause |
| SQL Server |
N/A |
|
| DB2 Common Servers |
N/A |
|
| Informix |
First and following extensions |
NEXT SIZE clause of the CREATE TABLE command |
| DB2/400 |
N/A |
|
Notes:
-
The value of this property is only considered when the table is created.
-
If no value is specified for this property then no clause that indicates the size of table extensions will be generated (there is no default value). Each DBMS, in this case, has its own default values (refer to the DBMS documentation).
Objects: Tables, Indexes
Initial Size Property
Next Extents Percentage Increase Property
Minimum Number of Extents Property