Checking Oracle object size limits

An extent is a user-defined unit of storage in the Oracle storage clause used when defining an Oracle object. It is used as MINEXTENTS or MAXEXTENTS in the storage clause. An Oracle object (that is, a table, an index, a rollback segment) grows one extent in size each time the object needs to be expanded.

When the maximum allowed number of extents is reached, the object will not be able to grow further. The object needs to be redefined so that either the size of each extent is increased or the initial object size is increased, to reduce the number of extents required for the storage of this object. The maximum allowed number of extents in a system is 2,147,483,645.

To check the number of extents:

1. Type dbused and press Enter.

   The system displays the Space Allocated screen.

2. Compare the value in the EXTENTS column to the value in the MAX_EXTENTS column.

   If the value in the EXTENTS column is greater than or equal to the value in the MAX_EXTENTS column, the table has reached its maximum size.

3. Redefine the database table storage, if necessary.

Note:
Contact your internal database administrator or your database vendor for help with this and other database tasks.

© 2006 Avaya Inc. All Rights Reserved.