Re: how to list all db's / tables?

> To list all tables you can do a
>
> SELECT table_name,owner
> FROM all_tables

Wrong! The correct command is:

SELECT table_name, owner
FROM dba_tables; Received on Thu Oct 18 2001 - 16:47:05 CDT