Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create Database Script..
Joel Garry wrote:
> arijitchatterjee123_at_yahoo.co.in (Arijit Chatterjee) wrote in message news:<ea01504d.0409030431.aae3d7e_at_posting.google.com>...
>
>>Respected Sir, >>when I writing >>======================== >>SQL> select * from tab; >>select * from tab >> * >>ERROR at line 1: >>ORA-00942: table or view does not exist >>======================= >>why this error is coming. >>Regards >>Arijit Chatterjee
Likely but not necessesarily. A table will show up in all_tables if you have been granted any privilege. So it could be there because you have been granted insert: Which does not mean you could ever select.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Sep 03 2004 - 18:41:43 CDT