Considering the upper limit on extents

Do not allow a table to acquire a large number of extents because an upper limit exists on the number of extents allowed. Trying to add an extent after you reach the limit causes error -136 (No more extents) to follow an INSERT request.

To help ensure that the limit is not exceeded, the database server performs the following actions:
  • The database server checks the number of extents each time that it creates an extent. If the number of the extent being created is a multiple of 16, the database server automatically doubles the next-extent size for the table. Therefore, at every 16th creation, the database server doubles the next-extent size.
  • When the database server creates an extent next to the previous extent, it treats both extents as a single extent.

Copyright© 2018 HCL Technologies Limited