Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between oracle Synonyms and Views.

Re: Difference between oracle Synonyms and Views.

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 29 Oct 2003 17:46:12 GMT
Message-ID: <bnoud4$sql7g$1@ID-82536.news.uni-berlin.de>

> 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.ch
Received on Wed Oct 29 2003 - 11:46:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US