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 -> create view cross tables

create view cross tables

From: <zibinyang_at_gmail.com>
Date: 21 Feb 2005 11:51:58 -0800
Message-ID: <1109015518.780369.176930@g14g2000cwa.googlegroups.com> 





Hi all,


When I tried to use create view as select from a,b,c
it's show me the error says ORA-00942: table or view does not exist
but when I use select from a,b,c it does return some records.
what's could be the problems?


a,b,c table are in differnce scheam. is this because I do not have
rights to create view?


Thanks



Zibin
Received on Mon Feb 21 2005 - 13:51:58 CST












Original text of this message













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