8. SQL Statements : MODIFY : Modify...to Add_extend
 
Share this page                  
Modify...to Add_extend
To add pages to a table, specify MODIFY...TO ADD_EXTEND. To specify the number of pages to be added, use the WITH EXTEND=number_of_pages option. 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.
The MODIFY...TO ADD_EXTEND option does not rebuild the table or drop any secondary indexes.