REG: Synonyms

[vamsioracle]

hi



I have a synonym, i am able to get the data by select * from <synonym> table.
and when i use desc <synonym> it is showing the structure of the table. The synonym was created by some one. Now i want to see to which table the synonym is lnked to i.e, to which table this synonym belongs to.

how to go about that
please help me

thank you

[debasisdas]

Use the following query for the desired result.
[CODE=oracle]select TABLE_OWNER,TAB LE_NAME,DB_LINK from user_synonyms where SYNONYM_NAME='S YN_NAME';[/CODE]
or

[CODE=oracle]select OWNER ,TABLE_OWNER,TA BLE_NAME ,DB_LINK from all_synonyms where SYNONYM_NAME='S YN_NAME';[/CODE]