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.