Re: Same Synonyms for two table owners in a single instance

It is possible to have 2 synonyms with the same name in one instance. But, and I think this is what you want, you can't create 2 synonyms with the same name in one schema.
You can create a view, that contains the data of both tables:   create view ViewForTable1 as
  select col1, col2, ... from TO1.table1   union all
  select col1, col2, ... from TO2.table1

Alex

bsoberoi_at_my-deja.com wrote:
>
> Hi there,
>
> Is it posible to have same synonym for different scheama's in a same
> database instance?
>
> Suppose you have a table say 'table1'. Also you have two scheama's and
> the table owner is say TO1 and TO2. Now the tables should be referenced
> as TO1.table1 and TO2.table1
>
> Now can we create private synonym named table1 for TO1.table1 and also
> for TO2.table1 in the single instance of a database.
>
> I'll highly appreciate if someone could answer.
>
> Thanks
>
> Baljit
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 03 1999 - 07:22:58 CST