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: Public Synonyms on Tables - Good or Bad?

Re: Public Synonyms on Tables - Good or Bad?

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Tue, 29 Jan 2002 22:14:02 -0000
Message-ID: <n4F58.50282$ka7.8286912@news6-win.server.ntlworld.com>


The "alter session set schema" command (or whatever the syntax is) is, I think, a better solution to the problem in most cases.

Gad krosner <krosner_at_excite.com> wrote in message news:98dd002d.0201290556.189c5680_at_posting.google.com...
> Hi There!
>
> What are the pros and cons for having (or not having) public synonyms
> on tables? I work in a shop moving from Sybase to Oracle, and we
> don't seem to agree on a given path. I'd like to hear some opinions,
> or have some URLs to such discussions.
>
> Thanks,
>
> Gad.
Received on Tue Jan 29 2002 - 16:14:02 CST

Original text of this message

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