Re: ORA-00942: table or view does not exist

Which is, of course, the same problem.
Due to the nature of your questions you must be very new to Oracle. Many of your questions would have been resolved if would at least try to read the docs, or to get some formal instruction.

Regards,

Sybrand Bakker, Oracle DBA

<ben_knill_at_hotmail.com> wrote in message news:tcmmgu2ujuia31_at_corp.supernews.com...
> Thanks for your response, this helps but the error message has started
> reappearing. This time under the 'h' in vehicle!
>
> I have reduced the statement to this, and the error seems to appear on
> line 2, under vehicle.
>
> select book_ref,sum(veh_rate*rent_days)
> from owner.booking,owner.vehicle,owner.bookline
> group by book_ref;
>
> Regards,
>
> Ben Knill
> 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/
> >
> >
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Thu Apr 05 2001 - 10:03:33 CDT