onspaces -d: Drop a space

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

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onspaces -d--+-dbspace----------+--+-----+------------------><
                +-blobspace--------+  '- -y-'   
                +-plogspace--------+            
                +-+-----+--sbspace-+            
                | '- -f-'          |            
                '-extspace---------'            

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. 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.


Copyright© 2019 HCL Technologies Limited