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 -> Re: Create Database Script..

Re: Create Database Script..

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 03 Sep 2004 16:41:43 -0700
Message-ID: <1094254962.59351@yasure>


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

>
>
> Try select table_name from all_tables to see what you can select from.
>
> jg
> --
> @home.com is bogus.
> Verrrry Suspicious:
> http://www.signonsandiego.com/uniontrib/20040902/news_1b2oracle.html

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

Original text of this message

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