Oracle 12cでシノニムの参照先オブジェクトを確認
環境
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'
結果
OWNER TABLE_OWNER TABLE_NAME CFTUSER YAMUSER CFTSYN