DROP CONTEXT

Purpose

Use the DROP CONTEXT statement to remove a context namespace from the database.

Note: 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.

See Also: CREATE CONTEXT and Oracle9i Database Concepts for more information on contexts

Prerequisites

You must have the DROP ANY CONTEXT system privilege.

Syntax

drop_context::=

Text description of drop_context

Keywords and Parameters

namespace

Specify the name of the context namespace to drop. You cannot drop the built-in namespace USERENV.

See Also: SYS_CONTEXT for information on the USERENV namespace

Example

Dropping an Application Context: Example

The following statement drops the context created in CREATE CONTEXT:

DROP CONTEXT hr_context;