12.Oracle杂记——数据字典dba_synonyms

12.Oracle杂记——数据字典dba_synonyms

视图dba_synonyms是关于同义词的信息查询。

查看视图如下：

sys@PDB1> desc dba_synonyms

 Name                                                                                                     Null?         Type

 ------------------------------------------------------------- ------------------------------------

 OWNER                                                                                                                   NOT NULL VARCHAR2(128)

 SYNONYM_NAME                                                                                              NOT NULL VARCHAR2(128)

 TABLE_OWNER                                                                                                               VARCHAR2(128)

 TABLE_NAME                                                                                     NOT NULL VARCHAR2(128)

 DB_LINK                                                                                                                             VARCHAR2(128)

 ORIGIN_CON_ID                                                                                                                              NUMBER

列描述如下：

OWNER  ：同义词的拥有者

 SYNONYM_NAME                                 ：同义词名字

 TABLE_OWNER   ：同义词

 TABLE_NAME      ：同义词相关的对象名字

 DB_LINK                                   ：相关的databaselink的名字

 ORIGIN_CON_ID                  ：数据来源的容器ID