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

On Wed, 04 Apr 2001 14:30:10 -0000, <ben_knill_at_hotmail.com> wrote:

>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

The affected table is not in your own schema, and you have privilege through a role. Roles are ignored during view compilation. You need to obtain a direct grant.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Apr 04 2001 - 16:46:56 CDT