OraFAQ Forum: SQL & PL/SQL » Definition in Synonym

Home » SQL & PL/SQL » SQL & PL/SQL » Definition in Synonym (Oracle 9i,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Definition in Synonym [message #353786]

Wed, 15 October 2008 02:02

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi all,

A synonym is simply an alias. It requires no storage other than its definition in the data dictionary.

Can anybody tell me, What is "definition" here?

Thanks & Regards,
Balaji.C

Report message to a moderator

Re: Definition in Synonym [message #353789 is a reply to message #353786]

Wed, 15 October 2008 02:11

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I think Definition in the data dictionry means the Synonym_name goes in to the data dictionary tables when we create synonym.

i.e. in all_synonyms, user_synonyms, dba_synonyms

Thanks,

Report message to a moderator