Note
This view is available starting with V2.2.30.
Purpose
This view displays all synonyms that the current user can access.
Applicability
This view applies 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 name of the object referenced by the synonym. The TABLE_NAME here is just a column name. A synonym can also refer to other objects, such as views. |
| 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 refers to a DB link. |
Sample query
Query all synonyms that the current user can access.
obclient [SYS]> SELECT * FROM SYS.ALL_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
View all synonyms in the current tenant: DBA_SYNONYMS
View all synonyms owned by the current user: USER_SYNONYMS
For more information about synonyms, see Manage synonyms.