Re: Corporate Wide Public Synonyms ++ multiple schemas

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:4O6dnbptZZ-VTpHfRVn-hw_at_comcast.com...
>
> actually my point is that a single application uses multiple schemas --
> which in my experience is typically the case. there are always at lease a
> few common tables, and there are often cross-schema references. in other
> words, not every table that the application accesses is always going to be
> in the target schema
>

Hi Mark,

Interestingly, my experience has been the quite the opposite with most applications I've worked with deriving it's data from the one schema, although there have been exceptions.

But yes, that being the case, my specific solution would be problematic. However, back to the OP, prevention is the best cure and while one has the chance, avoid public synonyms, especially if significant scalability is a requirement.

Cheers

Richard Received on Mon Feb 14 2005 - 06:05:08 CST