onspaces -d: Drop a space

Use the onspaces -d option to drop a dbspace, blobspace, plogspace, sbspace, or extspace.Use the onspaces -d option to drop a dbspace, blobspace, sbspace, or extspace.

Figure 1: Syntax:


Element	Purpose	Key considerations
-d	Indicates that a storage space is to be dropped	You can drop a dbspace, blobspace, plogspace, sbspace, or extspace while the database server is online or in quiescent mode. You can drop a dbspace, blobspace, sbspace, or extspace while the database server is online or in quiescent mode. After you drop a storage space, you must back it up to ensure that the sysutils database and the reserved pages are up-to-date. Run oncheck -pe to verify that no table is storing data in the dbspace, blobspace, or sbspace.
-y	Causes the database server to automatically respond yes to all prompts	None.
-f	Drops an sbspace that contains user data and metadata	You must use the -f (force) option to drop an sbspace that contains data. Restriction: Use the -f option with sbspaces only. Warning: If you use the -f option, the tables in the database server might have dead pointers to the smart large objects that were deleted with this option.
`blobspace`	Names the blobspace to be dropped	Before you drop a blobspace, drop all tables that include a TEXT or BYTE column that references the blobspace.
`dbspace`	Names the dbspace to be dropped	Before you drop a dbspace, drop all databases and tables that you previously created in the dbspace.
`extspace`	Names the extspace to be dropped	You cannot drop an extspace if it is associated with an existing table or index.
`plogspace`	Names the plogspace to be dropped	The plogspace must be empty to be dropped.
`sbspace`	Names the sbspace to be dropped	Before you drop an sbspace, drop all tables that include a BLOB or CLOB column that references the sbspace.

Important: Do not specify a path name when you drop these storage spaces.

This command has an equivalent SQL administration API function.