Name
Autoextend_Clause
Synopsis
AUTOEXTEND {OFF | ON [NEXTinteger
[K | M]] [MAXSIZE {integer
[K | M] | UNLIMITED}] }
Specifies whether or not files will be permitted to grow in size. When files are allowed to grow in size, this clause also specifies the growth parameters.
Keywords
- OFF
Specifies that the autoextend feature should not be enabled and that the file will not be permitted to grow in size.
- ON
Specifies that when the file becomes full and additional space is requested, the file will be extended in size by the amount specified by the NEXT parameter, up to the limit specified by the MAXSIZE parameter.
- NEXT
Specifies the amount of space in bytes, kilobytes (K), or megabytes (M) that will be added to the file when growth occurs.
- MAXSIZE
Specifies the maximum size in bytes, kilobytes (K), or megabytes (M) for the file. The autoextend feature does not extend the file beyond this size.
- UNLIMITED
Specifies that the file is permitted to grow up to the capacity of the physical disk or the maximum size permitted by the operating system, whichever is less.
Get Oracle in a Nutshell 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.