Purpose
The DROP CONTEXT statement is used to remove a context namespace from the database.
After a context namespace is removed, the context values set in the current session are retained. However, subsequent attempts to set the context will fail because the namespace no longer exists.
Notice
You must have the DROP ANY CONTEXT system privilege.
Syntax
DROP CONTEXT context_name
Parameters
context_name specifies the name of the context to be removed. You cannot remove the built-in USERENV namespace.
For information about the USERENV context, see the function SYS_CONTEXT.
Examples
Drop the dev_context context created by using CREATE CONTEXT.
obclient> DROP CONTEXT dev_context;