Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
Use the DROP
CONTEXT
statement to remove a context namespace from the database.
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.
Prerequisites
You must have the DROP
ANY
CONTEXT
system privilege.
Syntax
drop_context::=
Semantics
namespace
Specify the name of the context namespace to drop. You cannot drop the built-in namespace USERENV
.
Example
Dropping an Application Context: Example The following statement drops the context created in CREATE CONTEXT:
DROP CONTEXT hr_context;