Re: Yet another small question....

From: David Thornton <david.thornton_at_dowdigital.com.au>
Date: 1998/03/16
Message-ID: <350D34C3.828F8CA7@dowdigital.com.au>#1/1

You didn't mention which version of Oracle and SQL*Plus you are using.

If you are using SQLPLUS 8.0.3 this is actually a bug. (You can still view the tables by prefixing with sys.user_tables)

It is fixed in release 8.0.4

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!
>
> **************************
> Jeppe Sverdrup Brynjulfsen
> jeppe.brynjulfsen_at_eunet.no
> Den Polytekniske Høyskolen
Received on Mon Mar 16 1998 - 00:00:00 CST