Purpose
The DROP CONTEXT statement is used to remove a context namespace from the database.
After the context namespace is deleted, any context values that have already been set in the current session will be retained. However, any subsequent attempts to set values for that 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 dropped. You cannot drop the built-in namespace USERENV.
For more information about the USERENV context, see the function SYS_CONTEXT.
Examples
Drop the dev_context context created in CREATE CONTEXT.
obclient> DROP CONTEXT dev_context;
