Note
This view is available starting with V3.2.4.
Purpose
This view displays the context namespaces in the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| NAMESPACE | VARCHAR2(128) | NO | The name of the context namespace. |
| SCHEMA | VARCHAR2(128) | NO | The username of the package to which the attributes of the namespace belong. |
| PACKAGE | VARCHAR2(128) | NO | The name of the package to which the attributes of the namespace belong. |
| TYPE | VARCHAR2(22) | NO | The type of the context. |
| ORIGIN_CON_ID | NUMBER | NO | The tenant ID. |
| TRACKING | VARCHAR2(3) | NO | This parameter is for compatibility. Its value is fixed to YES. |
Sample query
Query the context namespaces in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_CONTEXT;
The query result is as follows:
+------------+--------+-------------------+------------------+---------------+----------+
| NAMESPACE | SCHEMA | PACKAGE | TYPE | ORIGIN_CON_ID | TRACKING |
+------------+--------+-------------------+------------------+---------------+----------+
| SALES_CTX | SYS | SET_SALES_CTX_PKG | ACCESSED LOCALLY | 1004 | YES |
| REGION_CTX | SYS | REGION_CTX_PKG | ACCESSED LOCALLY | 1004 | YES |
| DEPT_CTX | SYS | DEPT_CTX_PKG | ACCESSED LOCALLY | 1004 | YES |
+------------+--------+-------------------+------------------+---------------+----------+
3 rows in set
References
For more information about the syntax and usage of the CREATE CONTEXT statement, see CREATE CONTEXT.