Re: Create Database Script..

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 07 Sep 2004 17:09:48 -0700
Message-ID: <1094602251.357450@yasure>

Joel Garry wrote:

> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1094254962.59351_at_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.

>
>
> D'Oh!
>
> I've made that mistake before. Here, I was just wondering if there
> actually was a table named tab.
>
> jg
> --
> @home.com is bogus.
> "Over 500 IT Professionals have not requested a look at JS Tuner." -
> Dan Hotka

There isn't:

   1 SELECT object_name, object_type
   2 FROM dba_objects
   3* WHERE object_name = 'TAB'
SQL> / OBJECT_NAME

OBJECT_TYPE

TAB
VIEW TAB
SYNONYM TAB
SYNONYM

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Sep 07 2004 - 19:09:48 CDT