Maximum Extent Limits (ORCL)

From DBArtisan
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

When an object reaches its maximum extent limit, it cannot acquire any new free space. This can cause critical problems in a production database. DBArtisan’s Maximum Extent Limits for Oracle tool lets you quickly find and correct space problems.

Opening the Maximum Extent Limits Dialog Box

  1. On the Utilities menu, select Maximum Extent Limits.
    DBArtisan opens the Maximum Extent Limits dialog.

The table below describes the options and functionality on Maximum Extent Limits dialog.

Option Description

Object Owner

Lets you select owner of the objects to display the Objects box.


Objects for the user account(s) that have reached their maximum extent limit.

Edit Button

To increase an object’s maximum extent limit, edit the object and adjust its maximum extent property to a higher value or to unlimited.