| Table of Contents |
|---|
Version
All versions
Explanation
The following error message is output when ALTER TABLESPACE ... DROP DATAFILE is executed:
| Code Block | ||
|---|---|---|
| ||
iSQL> ALTER TABLESPACE SYS_TBS_DISK_DATA
2 DROP DATAFILE '/altibase/dbs/DISK_DATA2.dbf';
|
| Note |
|---|
Cause
The following error description can be viewed with the AltiErr utility:
| Panel |
|---|
$ altierr 0x0109D # *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:
| Panel |
|---|
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