Error 1127



Message text

Internal Error:  The OAM has no room for new inserts.  Check OAM for object %ld, index %d.


The object allocation map (OAM) tracks information about the allocation and deallocation of storage space for tables and indexes. At least one OAM page exists for each table (except syslogs and sysgams) and for the table’s indexes. The OAM page has an entry for each allocation page used by the object. The first OAM page for an object has a maximum of 240 entries, and any subsequent OAM pages have a maximum of 250 entries per page.

When a new page is allocated for the table or index:

Error 1127 is raised:


There are different ways to correct this error, depending on the conditions under which it occurred and the nature of the OAM problem. Other errors may also be raised at the same time.

Additional information

For information about OAM pages, refer to “Checking Database Consistency” in the System Administration Guide: Volume 2, and see the section “Understanding page and object allocation concepts.”

Before calling Sybase Technical Support, have the information on hand that is listed in “Reporting errors”, including the output of dbcc listoam for the table.

Versions in which this error is raised

All versions