17
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:
There is not enough space in the database to create the index. Usually this error occurs with error 1105.
No more locks are available.
Unfortunately, there is no straightforward way to identify which problem caused the error.
Select the appropriate action from the sections below.
Use either of the following two strategies to correct this error:
Use the instructions from Error 1505 to increase the space available in your database.
Move the table where the index is to be created to a different, larger, user-defined segment, and then create the index. Refer to “Creating and Using Segments” in the System Administration Guide: Volume 2 for instructions.
Determine whether you have enough space available on the new segment by typing:
1> sp_helpsegment <segment_name> 2> go
Verify that the database where you want to create your index has enough space allocated on the device or devices that contain the segment from the above query:
1> sp_helpdb <database_name> 2> go
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.
Refer to “create index” in the Reference Manual: Commands.
All versions
