The DELETE COLLATING_SEQUENCE statement deletes the named collating sequence. If you have defined a global field or database using the named collating sequence, you cannot delete the collating sequence. (B)0[m[4mDELETE[m [4mCOLLATING_SEQUENCE[m qq> sequence-name. 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 COLLATING_SEQUENCE statement.
1 – More
You must have the DELETE privilege to the database to use the DELETE COLLATING_SEQUENCE statement.