Re: Difference between oracle Synonyms and Views.

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Tue, 28 Oct 2003 19:52:37 GMT
Message-ID: <9Oznb.24872$4O1.23243@nwrdny01.gnilink.net>

"Simon Adebisi" <omar_adebisi_at_hotmail.com> wrote in message news:f1e58c26.0310281138.b5bc3be_at_posting.google.com...
> Prem:
>

--snip--
>
> 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.

What???????????
Joking right?

>
> A View, on the other hand, is sort of like a clustered index.
Again Joking .. right?

>
> Hope this helps mate. Glad to be back!
>
> Cheers,
>
> Simon Adebisi, OCP
> Sr. Oracle Architect

^^^
Joking? right?

>

--snip--

Anurag Received on Tue Oct 28 2003 - 13:52:37 CST