8. SQL Statements : MODIFY : With Clause Options for Modify : Page_size
 
Share this page                  
Page_size
Specify page size using PAGE_SIZE = n where n can be the page size in the following table:
Page Size
Number of Bytes
2K
2,048
4K
4,096
8K
8,192
16K
16,384
32K
32,768
64K
65,536
The default page size is 8192. The tid size is 8. The buffer cache for the installation must also be configured with the page size you specify in create table or an error occurs.