Re: Ways to list available tables?

Use select owner, table_name from all_tables to see which tables you have access to.
chances are you don't have a synonym.
If the table lotevents shows up
you should try
select * from <owner>.lotevents.
If this works you should create a private synonym: create synonym lotevents for <owner>.lotevents;

References to user_tables and dba_tables in another post are incorrect. Most likely your account doesn't own the table so it won't show up in user_tables. To dba_tables you shouldn't have access. It occurs quite often people don't like to resolve privilege problems because they are a bit lazy and grant dba privilege to about everyone.

Hth,

Sybrand Bakker, Oracle DBA

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. . .
> --------------------------------------------

--