Oracle 12cでシノニムの参照先オブジェクトを確認

2014年3月23日2021年11月11日

環境
Oracle 12.2.0.1.0

書式
SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'シノニム名’

使用例

SELECT

OWNER,

TABLE_OWNER

, TABLE_NAME,

FROM

ALL_SYNONYMS

WHERE

SYNONYM_NAME = 'CFTSYN'

SELECT OWNER, TABLE_OWNER , TABLE_NAME, FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'CFTSYN'

SELECT
 OWNER,
  TABLE_OWNER
  , TABLE_NAME, 
FROM
  ALL_SYNONYMS 
WHERE
  SYNONYM_NAME = 'CFTSYN'

結果

OWNER TABLE_OWNER TABLE_NAME

CFTUSER YAMUSER 　　　　CFTSYN

OWNER TABLE_OWNER TABLE_NAME CFTUSER YAMUSER 　　　　CFTSYN

OWNER       TABLE_OWNER	    TABLE_NAME
CFTUSER      YAMUSER	　　　　CFTSYN

Posted by arkgame