ERR-11030

The data file cannot be extended because the requested size is bigger than the maximum size (262144 pages)

Version
Explanation
Cause
Action
Reference

Version

4.3.9 or above

Explanation

1. Unable to change the datafile size of the disk tablespace.

2. Unable to resize the undo tablespace datafile.

Cause

1. The user has attempted to change the size of a datafile that has the AUTOEXTEND option OFF to a value bigger than the maximum size.

2. The value of the undo tablespace datafile to be resized exceeded SYS_UNO_FILE_MAX_SIZE.

Action

Set the AUTOEXTEND option of datafile to ON and follow the steps as below to change the datafile size.

1. Change the AUTOEXTEND option

iSQL>ALTER TABLESPACE DISK_USER_TBS
   2 ALTER DATAFILE '/home/altibase_home/dbs/user.dbf' AUTOEXTEND ON;
Alter success.

2. Change the datafile size

iSQL> ALTER TABLESPACE DISK_USER_TBS
   2  ALTER DATAFILE '/home/altibase_home/dbs/user.dbf' SIZE 100M;
Alter success.

3. Increase SYS_UNDO_FILE_MAX_SIZE

Change SYS_UNDO_FILE_MAX_SIZE from $ALTIBASE_HOME/conf/altibase.properties to the desired size (in bytes) and recreate the database.

Reference

In order to change this property, the database has to be recreated.

Hence, if you want to increase the undospace size, it is easier to use the ALTER TABLESPACE command to add a datafile.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.