Re: Ways to list available tables?

Fairly simple. In sqlplus type:

    select owner, table_name from all_tables;

The owner will need to be put in front of the table you are trying to access.

    select * from owner.table_name;

Terry Ball
Sr. DBA, CSG Systems

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
Received on Thu Dec 10 1998 - 00:00:00 CST