You can remove a file from the RLV dbspace, provided that it is not the only file, and
it is not in use.
Prerequisites
- SAP Sybase IQ server has a simplex database.
- A single RLV dbspace exists on the database.
- The RLV dbspace is read-only, or the file is not in use if the dbspace is
read-write.
TaskUse the statement ALTER DBSPACE
<dbspace name>
DROP FILE
<dbspace filename>
ALTER DBSPACE d1 DROP FILE rlv2