Error 1510



Message text

Sort failed: Out of space in database '%.*s'


Adaptive Server uses a clustered index to sort rows so that their physical order is the same as their logical (indexed) order. When creating a clustered index, Adaptive Server needs a considerable amount of space, 120 to 150  percent of the size of the table, because it needs to sort the data in the table first and then create the clustered index on the sorted data. This space should be available in the database or on the segment where you want to create your index.

Error 1510 occurs when you try to create an index and one of the following is true:

Unfortunately, there is no straightforward way to identify which problem caused the error.


Select the appropriate action from the sections below.

Not enough space in the database

Use either of the following two strategies to correct this error:

No more locks available

If the 1510 error occurs because Adaptive Server has no more locks available, use sp_configure to increase the number of locks:

1> sp_configure "number of locks", <new_value>
2> go

Shut down and restart Adaptive Server to initialize the new configuration parameter value.

Refer to “Setting Configuration Parameters” in the System Administration Guide: Volume 1, and “Configuring Memory” in the System Administration Guide: Volume 2 for more information.

Additional information

Refer to “create index” in the Reference Manual: Commands.

Versions in which this error is raised

All versions