Version

All the versions of Altibase

Symptom

The following error occurs when executing alter tablespace ~ drop datafile.

Cause

The description of the error can be checked using the altierr utility as follows.

Data files that have been used at least once cannot be deleted.

Even if all the data files have only free space by inserting and then deleting them, data files that have been used once cannot be deleted.

The above error occurs when you try to drop a data file that has been used at least once.

For reference, data files that have never been used can be dropped.

Solution

There is no way to drop data files that have been used at least once.

To drop the data file, the tablespace must be recreated.

The following steps are required to recreate the tablespace.