Oracle | Contexts

Oracle Contexts Version 19c

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Dependencies

ALL_CONTEXT	DBA_CONTEXT	SESSION_CONTEXT
CDB_CONTEXT	GLOBAL_CONTEXT	V$CONTEXT
CONTEXT$		CDB_GLOBAL_CONTEXT CONTEXT CONTEXT_V2 GV$GLOBALCONTEXT INT$DBA_CONTEXT I_CONTEXT KU$_CONTEXT_T KU$_CONTEXT_VIEW SEMCONTEXT USER_POLICY_CONTEXTS V$GLOBALCONTEXT VALIDATE_CONTEXT

Create Context

Create local context CREATE OR REPLACE CONTEXT <context_name> USING <plsql_package_name>;

CREATE OR REPLACE CONTEXT otp USING dbms_otp;

      

      col schema format a30

      col package format a30

      

      SELECT *

      FROM context$

      WHERE package = 'DBMS_OTP';

      

         OBJ# SCHEMA                         PACKAGE        FLAGS

      ------- ------------------------------ ------------- ------

        76296 SYS                            DBMS_OTP           0

Create global context CREATE OR REPLACE CONTEXT <context_name> USING <plsql_package_name> ACCESSED GLOBALLY;

CREATE OR REPLACE CONTEXT otp USING dbms_otp ACCESSED GLOBALLY;

      

      col schema format a30

      col package format a30

      

      SELECT *

      FROM context$

      WHERE package = 'DBMS_OTP';

      

         OBJ# SCHEMA                         PACKAGE        FLAGS

      ------- ------------------------------ ------------- ------

        76297 SYS                            DBMS_OTP           2

Drop Context

Drop Context drop context <context_name>;

drop context otp;