auto_extend_clause
The following is the syntax for the autoextend_clause in the ALTER TABLESPACE statement:
AUTOEXTEND
{
OFF |
ON [NEXT integer[K | M] x
[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.
