Re: Difference between oracle Synonyms and Views.

Before making snide remarks about other folk's answers, be sure yours is right:

A synonym is NOT a copy of the data , it is just an entry in the dictionary that references the actual table and allows access without using the fully-qualified table name.. Do you really think that if I have 200 tables and create a synonym for each of them, I now have twice as much data stored?????( could really use up disk space in a hurry...)

Views are not even remotely like a clustered index., if like anything they are like sub queries that are pre-written.

...

omar_adebisi_at_hotmail.com (Simon Adebisi) wrote:

>Prem:
>
>True to form, that wanker Dan Morgan doesn't know the answer and once
>again sends someone to an unsupported reference site.
>
>Quite simply:
>
>A Synonym creates a copy of the data but under a different name. You
>see, you don't want people having to remember difficult names. Plus it
>allows for data redundancy which cuts down on having to buy more kit.
>This may influence the backup schedule but, who knows, give 'er a try.
>
>A View, on the other hand, is sort of like a clustered index.
>
>Hope this helps mate. Glad to be back!
>
>Cheers,
>
>Simon Adebisi, OCP
>Sr. Oracle Architect
>
>
>
>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1067305536.430390_at_yasure>...
>> Prem wrote:
>>
>> >Hi oracle gurus,
>> >
>> >I am confused about the synonyms in Oracle. I just wanted to know the
>> >difference between Synonyms and views.
>> >Please help me in this matter.
>> >Thank you in advance.
>> >
>> >Prem Kalani.
>> >
>> >
>> The difference? There isn't even a relationship between them. You have
>> asked a question that
>> is roughly equivalent to what is the relationship between Mt. Everest
>> and a seagull.
>>
>> I would suggest you go to http://tahiti.oracle.com and look these two
>> items up.
>>
>> I could easily supply you with the answer. As could just about everyone
>> here. But quite
>> frankly I think it would be doing you a disservice. Get familiar with
>> tahiti and you will find
>> the answers to these and many more questions.
Received on Tue Oct 28 2003 - 13:59:18 CST