Re: Yet another small question....

jeppe.brynjulfsen_at_eunet.no (Jeppe Sverdrup Brynjulfsen) wrote:

>I am used to the command
>SELECT * FROM user_tables; to list all the tables in the connected
>database. But I have no user_tables in the system. I thought there
>always was a user_tables in the database. How can I list up all the
>tables when I do not have a user_tables?
>
>
>Thank you very much, and have a nice day!
>

Did you get no rows selected or "object user_tables does not exist" ?

If you got the first its because you don't have any tables. If you got the second its because the synonym for the SYS.USER_TABLES view was not created. Do a  

desc sys.user_tables

if its there then

create public synonym user_tables for sys.user_tables;

run the command as sys Received on Sun Mar 01 1998 - 00:00:00 CST