Purpose
You can use the DROP CONTEXT statement to drop a context namespace from the database.
After you drop a context namespace, a context set in this namespace for a user session is still valid. However, when the user attempts to set this context again, the context becomes invalid.
Notice
You must have the DROP ANY CONTEXT system privilege.
Syntax
DROP CONTEXT namespace;
Parameters
namespace specifies the name of the context namespace to be dropped. You cannot drop the built-in namespace USERENV.
For more information about the USERENV namespace, see SYS_CONTEXT.
Examples
Drop the dev_context context created in CREATE CONTEXT.
obclient> DROP CONTEXT dev_context;
Query OK, 0 rows affected