You must have the Oracle Rdb DELETE privilege to a relation to delete the relation with the DELETE RELATION statement. If the database is created with the DICTIONARY IS REQUIRED option, you must invoke the database by path name, rather than file name, before you issue this statement. You cannot delete a relation when there are other active transactions involving the relation. That is, you must have EXCLUSIVE access to the relation. If a view definition refers to a relation you want to delete, you must delete that view definition before you delete the relation. If a constraint in the database references a relation, you cannot delete that relation until you delete the constraint that references the relation. 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 RELATION statement.