ERR-11036

The data file is in use

Version
Explanation
Cause
Action
Reference

Version

All versions

Explanation

The following error message is output when ALTER TABLESPACE … DROP DATAFILE is executed:

iSQL> ALTER TABLESPACE SYS_TBS_DISK_DATA
    2 DROP DATAFILE '/altibase/dbs/DISK_DATA2.dbf';

ERR-11036: The data file is in use.

Cause

The following error description can be viewed with the AltiErr utility:

$ altierr 0x0109D
0x11036 ( 69686) smERR_ABORT_CannotRemoveDataFileNode The data file is in use.

# *Cause: The data file is in use.

# *Action: Please remove an unnecessary data file.

Even if the user executed an INSERT statement and followed it with a DELETE statement so that all the datafiles can only have free pages, a previously used datafile cannot be dropped.

This error occurs when an attempt is made to drop a datafile that has previously been used.

Only datafiles that have never been used can be dropped.

Action

It is impossible to drop a datafile that was used even once.

To drop a datafile, the tablespace must be recreated as below:

1. Export the data and object scripts that are created in the tablespace.

2. Drop and create the tablespace.

3. Import the data and create the object.

Reference

N/A

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.