Common SQL DDL Clauses

SQL data definition clauses that appear in multiple
SQL statements.

allocate_extent_clause
constraints
deallocate_unused_clause
file_specification
logging_clausen parallel_clause
physical_attributes_clause
storage_clause



allocate_extent_clause
Purpose
Use the allocate_extent_clause clause to explicitly allocate a new extent for a
database object.
Explicitly allocating an extent with this clause does not change the values of the
NEXT and PCTINCREASE storage parameters, so does not affect the size of the next
extent to be allocated implicitly by Oracle.