autoextend_clause

The following is the syntax for the autoextend_clause in the CREATE TABLESPACE statement:

AUTOEXTEND 
   {
   OFF |
   ON [NEXT integer[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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset