Delete a dbspace from the database.
Prerequisites
- Space Admin authority is required.
- You must be the only user connected to the database in order to delete a catalog dbspace (you can become the only connected user by dropping all secondary nodes).
- You cannot drop the six initial dbspaces SYSTEM, TEMPORARY, IQ_SHARED_TEMP, IQ_SYSTEM_MAIN, IQ_SYSTEM_TEMP, and IQ_SYSTEM_MSG. You may drop dbspaces from the IQ main store or catalog store, which may contain multiple dbspaces, as long as at least one dbspace remains with readwrite mode.
- The dbspace must contain no user data or user created objects.
Task- In the Perspective Resources view, highlight the resource and select .
- In the left pane of the Administration Console view, select .
- In the Dbspaces view, highlight the dbspace to delete.
- Hover the mouse pointer over the dbspace and click the arrow.
- Select Delete.
- Click Yes.