SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 9 of 26

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 statements_845.gif follows

Text description of drop_context

Semantics

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;