Oracle | Contexts

Oracle Contexts Version 19c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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;