Modify...to Add_extend Option
To add pages to a table, specify modify...to add_extend. To specify the number of pages to be added, use the extend=number_of_pages option. If you omit the with extend=number_of_pages option, 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.
Last modified date: 01/30/2023