Empty a DB file and move the objects in the file to another available read-write DB file.
Prerequisites
- DBA authority is required.
- The dbspace must be in read-write mode.
- The DB file should be read-only.
Task- In the Perspective Resources view, highlight the resource and select .
- In the left pane of the Administration Console view, select .
- In the DB Files view, highlight the DB file to empty.
- Hover the mouse pointer over the DB file and click the arrow.
- Select Empty File.
- Click Yes to continue.
Objects in the DB file are moved to another read-write DB file in the same dbspace.