Re: Ways to list available tables?

Run the following simple query to get a list of the objects that you can access:-

SELECT owner, object_name FROM all_objects;

(NB: You could use all_tables instead of all_objects but you may find you need to access other object types as well, for example a view).

If lotevents appears in this list then to make your query work add the owner name (and a period) to the beginning of each object referenced in your code, for example

SELECT * FROM david.loteverts;

alternatively, create a private synonym for these objects, for example

CREATE SYNONYM lotevents for david.lotevents;

If lotevents is NOT in this list then you can't access it, and you should poke your lazy unhelpful DBA with a dirty stick until you get some action. It's his job to set the database up in a way that ALL users have the best environment for the work they need to do.

TNKS wrote in message <74nkce$12uu$1_at_newsgate.sps.mot.com>...
>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:
>
>
Received on Thu Dec 10 1998 - 10:31:52 CST