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: Same Synonyms for two table owners in a single instance

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

From: Alexander Moeckel <Alexander.Moeckel_at_IBYKUS.de>
Date: Fri, 03 Dec 1999 14:22:58 +0100
Message-ID: <3847C432.4A46C97C@IBYKUS.de>


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

Original text of this message

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