Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
Apart from the comments of others in this group about the technical accuracy of your post (which I share): If people don't want to remember difficult names, why not create the objects with easy names in the first place?
Rene
-- Rene Nyffenegger http://www.adp-gmbh.chReceived on Wed Oct 29 2003 - 11:46:12 CST