Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
The size_clause
lets you specify a number of bytes, kilobytes (K), megabytes (M), gigabytes (G), terabytes (T), petabytes (P), or exabytes (E) in any statement that lets you establish amounts of disk or memory space.
Syntax
size_clause::=
Semantics
Use the size_clause
to specify a number or multiple of bytes. If you do not specify any of the multiple abbreviations, the integer
is interpreted as bytes.
Note:
Not all multiples of bytes are appropriate in all cases, and context-sensitive limitations may apply. In the latter case, Oracle issues an error message.