Removing a context namespace does not invalidate any context under that namespace that has been set for a user session. However, the context will be invalid when the user next attempts to set that context.
You must have the
CONTEXT system privilege.
Specify the name of the context namespace to drop. You cannot drop the built-in namespace
See Also:SYS_CONTEXT for information on the
Dropping an Application Context: Example The following statement drops the context created in CREATE CONTEXT:
DROP CONTEXT hr_context;