Note
This view is available starting with V3.2.4.
Purpose
This view displays the information about all context namespaces in the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| NAMESPACE | VARCHAR2(128) | NO | The name of the context namespace. |
| SCHEMA | VARCHAR2(128) | NO | The user name of the package to which the attribute belongs. |
| PACKAGE | VARCHAR2(128) | NO | The name of the specified package to which the attribute belongs. |
| TYPE | VARCHAR2(22) | NO | The type of the context. |
| ORIGIN_CON_ID | NUMBER | NO | The tenant ID. |
| TRACKING | VARCHAR2(3) | NO | This column is for compatibility. The value is fixed to YES. |
Sample query
Query the information about all 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.