DROP CONTEXT

Syntax

Purpose

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 the next time the user attempts to set that context.

See Also: "CREATE CONTEXT" and Oracle8i Concepts for more information on contexts.

Prerequisites

You must have the DROP ANY CONTEXT system privilege.

Keywords and Parameters

namespace

is 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;