Empty a DB file and move the objects in the file to another available read-write DB file.
Prerequisites
- Authenticate with Sybase IQ using an account that has DBA authority.
- The dbspace must be in read-write mode.
- The DB file should be read-only.
Task- In the Perspective Resources view, select the resource and select .
- In the left pane of the Administration Console, expand and select DB Files.
- In the right pane, select a DB file to empty.
- Click the drop-down arrow that appears next to the DB file name and select Empty File.
- Click Yes to continue.
Objects in the DB file are moved to another read-write DB file in the same dbspace.