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

Syntax

Keywords and Parameters

namespace

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

Example

DROP CONTEXT Example

The following statement drops the context created in CREATE CONTEXT:

DROP CONTEXT hr_context;