Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
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
Semantics
Specify the name of the context namespace to drop. You cannot drop the built-in namespace USERENV
.
Example
The following statement drops the context created in CREATE CONTEXT :
DROP CONTEXT hr_context;