autoextend_clause
The following is the syntax for the autoextend_clause in the CREATE DATABASE statement:
AUTOEXTEND { OFF | ON [NEXTinteger
[K | M] [MAXSIZE {UNLIMITED |integer
[K | M] } ] }
- OFF
Turns the AUTOEXTEND feature off.
- ON
Turns the AUTOEXTEND feature on.
- NEXT
Specifies the size of the next file extent allocated.
- MAXSIZE
Specifies the maximum size to which the datafile can grow.
- UNLIMITED
Specifies that the datafile size is unlimited or, rather, limited by operating system limits.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.