Deletes a storage map. You cannot delete a storage map for a
relation that has data in it. If you attempt to do so, you will
receive an error message.
Example:
RDO> DELETE STORAGE MAP DEGREES_MAP.
1 – Format
(B)0[m[4mDELETE[m [4mSTORAGE[m [4mMAP[m qqqqqqqqqqqqqq> map-name qqqqqqqqqqqqq> .
1.1 – map-name
The name of the storage map definition you want to delete.
2 – More
To use the DELETE STORAGE MAP statement to delete a storage map
for a relation, you must have the Oracle Rdb DELETE privilege to the
relation.
You cannot delete a storage map that refers to a relation that
contains data. If you attempt to do so, you will receive an error
message. If a relation is deleted, the underlying storage map is
also deleted.
You must execute this statement in a read/write transaction.
If there is no active transaction and you issue this statement,
Oracle Rdb starts a read/write transaction implicitly.
Other users are allowed to be attached to the database when you
issue the DELETE STORAGE MAP statement.
3 – Example
The following example deletes the storage map TEST_MAP:
RDO> DELETE STORAGE MAP TEST_MAP.