Note
This view is available starting with V2.2.30.
Purpose
This view displays all synonyms in the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the synonym. |
| SYNONYM_NAME | VARCHAR2(128) | NO | The name of the synonym. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the object referenced by the synonym. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object referenced by the synonym. |
| DB_LINK | VARCHAR2(128) | NO | The name of the DB link if the synonym references a DB link. Currently, synonyms do not support DB links. |
Sample query
Query all synonyms in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_SYNONYMS;
The query result is as follows:
+----------+--------------+-------------+------------+---------+
| OWNER | SYNONYM_NAME | TABLE_OWNER | TABLE_NAME | DB_LINK |
+----------+--------------+-------------+------------+---------+
| __public | SYN_PUB | SYS | TEST | NULL |
| SYS | S1 | SYS | TEST | NULL |
+----------+--------------+-------------+------------+---------+
2 rows in set
References
Query all synonyms in the current tenant: ALL_SYNONYMS
Query all synonyms owned by the current user: USER_SYNONYMS
For more information about synonyms, see Manage synonyms.