Skip to content

tablespace does not have enough free space error#

Overview#

Insufficient tablespace

Version#

Altibase version 4 or later

Cause#

This error is caused by the insufficient size of a specific tablespace.

Solution#

  1. Check the tablespace space usage.

    Use the appropriate query statement for the version of Altibase you are using to check the usage.

  2. After querying the tablespace usage, add space to the tablespace with USAGE(%) close to 100% in the query result.

    iSQL> ALTER TABLESPACE tablespace name add datafile '/path/filename' size 2G autoextend off;
    

Reference#

When adding a data file, the tablespace is locked, so it is recommended to block the service and work.

For Altibase 5.3.3 or earlier, select and DML and queries will wait for the tablespace add operation to complete.

From Altibase 5.5.1 or later to the latest Altibase 6, DML waits until the tablespace addition operation is completed, but the select statement is executed normally.