Re: Ways to list available tables?

LOTEVENTS??? Is that part of the schema for REEGIS?

Oh, tmtowtdi. Here's 3:

select tname from tab;
select distinct object_name from user_objects   where object_type = 'TABLE';
select distinct table_name from user_tab_columns;

TNKS wrote:
>
> I'm an oracle user with a not-so-helpful database administrator. . .
>
> I'm trying to execute SQL statements to an account that she just set up for
> me, I've got a simple select statement showing me the data in a table I'm
> supposed to have access to, and the errors are as follows:
>
> SQL> @test
> SQL> set serveroutput on
> SQL> set echo on
> SQL> set feedback 20
> SQL>
> SQL> SELECT * from lotevents;
> SELECT * from lotevents
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> SQL> /
>
> Does anybody know of a way a simple user like myself can query the database
> for all the tables I can see. . . otherwise I have to deal with a person
> (our DBA), who historically beats around the bush, and stalls progress.
>
> Thanks in advances. . . also, if you all could send response to my E-mail
> address as directed below, I'd greatlys appreciate it.
>
> --TNKS
> --------------------------------------------
> To reply to this message. . .
> Please remove "NO" and "SPAM" from the address given.
>
> I apologize for this inconvenience, but it helps evade
> solicitations from distributors of silly things. . . like pornography. . .
> --------------------------------------------
>
> Payroll Service Center <rymk4a_at_email.sps.mot.com>
> VOICE:(888) 382-4176 or (602)
> Motorola
>
> Payroll Service Center
> VOICE:(888) 382-4176 or (602) <rymk4a_at_email.sps.mot.com>
> Motorola
> 426 North 44th Street Suite 150A Pheonix AZ 85008;Pheonix;Arizona;8008;Unites States of America
> Additional Information:
> Version 2.1
> Last Name Service Center
> First NamePayroll
> Label Work426 North 44th Street Suite 150A Pheonix AZ 85008 Pheonix, Arizoa 85008 Unites States of America
> Revision 19981210T045731Z

--
Gary

            -=- Avenue Programmers' Reference -=-    Class Hierarchy, Requests, and Hyperlinked Sample Scripts:

             http:/www.gator.net/~garyg/aveclass.htm Received on Mon Jan 11 1999 - 18:55:04 CST