To add pages to a blob extension table, specify modify...with blob_extend. To specify the number of pages to be added, use the 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.

The modify...with blob_extend option does not rebuild the table or drop any secondary indexes.