Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

What is this error?

Code Block
iSQL> CREATE TABLESPACE disk_tbs datafile 'dbf1.dbf' SIZE 10M AUTOEXTEND OFF;
iSQL> CREATE TABLE t2 (c1 CHAR(100)) TABLESPACE disk_tbs;
iSQL> INSERT INTO T2 VALUES ('1');
iSQL> INSERT INTO T2 SELECT * FROM T2;
.....
(repeat above SQL)
.....
iSQL> INSERT INTO T2 SELECT * FROM T2;
[ERR-11035 : The tablespace does not have enough free space ( TBS ID : 4, TBS Name :DISK_TBS, Type : 2, Used Page Limit : 128 ).]

As it is illustrated in the above example, an error message is displayed when a user tablespace's usage grows up to the limit specified at the initial creation of that tablespace.In this example it is 10Mbytes.
Please also note that this message is different for the versions of ALTIBASE HDB earlier than version 5.
How to check usage of a tablespaces? refer to this page.

How to resolve this error?

First, please check to make sure that in fact the user tablespace does not have enough resource (disk space in our example).
Second, execute the following DDL statements to expand the user tablespace.

Code Block
iSQL>ALTER TABLESPACE disk_tbs ADD DATAFILE 'dbf2.dbf' SIZE 10M AUTOEXTEND ON;

(if TBS name equals to "SYS_TBS_UNDO", execute below DDL)
iSQL> ALTER TABLESPACE sys_tbs_undo ADD DATAFILE 'undo002.dbf' size 1G autoextent on;