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: Union query between two different schemas

Re: Union query between two different schemas

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Tue, 30 Jan 2001 12:04:33 GMT
Message-ID: <l5yd6.43766$Tl3.7522210@typhoon.tampabay.rr.com>

Make sure that the user running the query has select privileges on both tables. Check by doing a desc on each (desc UserEOD.tbOfficertable). If it is not found, log in as UserEOD and grant select on tbOfficertable to the appropriate users.

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

Sally Madeira <sallym1_at_home.com> wrote in message news:YHxd6.163013$P82.19658608_at_news1.rdc1.ct.home.com...
> I have two users set up: UserFRF ans UserEOD. They both have the same
> tables but
> hold different information based on region. I need to do the following:
>
> SELECT Office, Region Officer FROM UserFRF.tbOfficertable
> UNION
> SELECT Office, Region Officer FROM UserEOD.tbOfficertable
>
> I get an error saying UserEOD.tbOfficertable not found (not sure what the
> real message was)
>
> I am doing this statement in User "UserFRF" and I am user version 8.0 on
 my
> test server
> and it also does not work on 8i on the production server.
>
> Question: Can this be done? I need this to be a view for our website.
>
> Sally
>
>
>
>
Received on Tue Jan 30 2001 - 06:04:33 CST

Original text of this message

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