MODIFY...TO ADD_EXTEND
To add pages to a table, specify MODIFY...TO ADD_EXTEND.
Syntax to add pages to a table:
MODIFY tablename|indexname TO ADD_EXTEND
[WITH EXTEND = number_of_pages]
where number_of_pages is 1 to 8,388,607.
If the WITH EXTEND=number_of_pages option is omitted, the DBMS Server adds the default number of pages specified for extending the table. To specify the default, use the MODIFY...WITH EXTEND statement. If no default has been specified for the table, 16 pages are added.
To add pages to a blob extension table, specify MODIFY...TO ADD_EXTEND WITH BLOB_EXTEND=number_of_pages.
Syntax to add pages to blob extension table:
MODIFY tablename|indexname TO ADD_EXTEND
[WITH BLOB_EXTEND = number_of_pages]
where number_of_pages is 1 to 8,388,607.
The MODIFY...TO ADD_EXTEND option does not rebuild the table or drop any secondary indexes.
Last modified date: 11/28/2023