Re: Difference between oracle Synonyms and Views.

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:38:40 CST