Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-00942: table or view does not exist
Hi,
I agree that the issue relates to ownership. Other options include creating a
public synonym for the tables, or the view once it's completed. If you can log
in as the owner you obviously won't need to qualify the table names.
One way or another though you've got to grant privileges so other users can see the view you're trying to create after you gain access to the tables.
Steve
timkarnold wrote:
> Who owns the tables booking, customer ,vehicle,book_line ?
> Try owner.booking, owner.customer etc.
>
> <ben_knill_at_hotmail.com> wrote in message
> news:tcmbvi4a3vr09a_at_corp.supernews.com...
> > I am trying to create a view to use as a report, I keep getting this error
> > message when it does'nt seem to recognise the tables customer, and
> > booking.
> > These tables DEFINATLY exist but I don't seem to be able to get around
> > this problem. Could someone give me some advise on creating this view!
> > The telnet response is:
> >
> > SQL> Create view customer_sales as
> > select cust_name, book_ref, sum(veh_rate*rent_days) "BOOKING COST"
> > from booking, customer ,vehicle,book_line
> > where customer.cust_no = booking.cust_no and
> > booking.book_ref = bookline.book_ref
> > group by cust_name;
> >
> > 2 3 4 5 6 from booking, customer ,vehicle,book_line
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> >
> >
> > SQL> SQL> Create view customer_sales as
> > select customer.cust_name, booking.book_ref, sum
> > (veh_rate*rent_days) "BOOKING C
> > OST"
> > from booking, customer ,vehicle,book_line
> > where customer.cust_no = booking.cust_no and
> > booking.book_ref = bookline.book_ref
> > group by cust_name;
> > 2 3 4 5 6 from booking, customer ,vehicle,book_line
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> >
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
Received on Wed Apr 04 2001 - 13:22:56 CDT