(column specifications) | Here is where you place your list of columns, the datatype, and column constraints. For example:
(PRODUCT_ID NUMBER(10,2), PRODUCT_NAME VARCHAR2(50), …) |
[PCTFREE n] | Percent of space saved for updates of current rows in the block. |
[PCTUSED n] | Maximum percent used before no more rows can be inserted into the block. |
INITIAL nK | Initial extent size. |
NEXT nK | Next extent size. |
MINEXTENTS n|UNLIMITED | Minimum extents to create when the table is created. |
MAXEXTENTS n | Maximum extents allowed. Specify a number or the word UNLIMITED. |
PCTINCREASE n | Percent increase of each subsequent extent over the previous one. |
tablespace_name |