Re: How to find the name of the schema on an existing Oracle 7 Database?

DBA_TABLES is accessable only by a DBA and lists every table in the system.

ALL_TABLES lists every table that YOU own or can access through grants.

Keith S. wrote:

> "Jesper Sivertsen" <siv_at_pip.dknet.dk> writes:
>
> >If i understand your question you wants to find out who owns tables !
 

> >If so use the following sql in sqlplus as the user system :
 

> >select distinct(owner) from dba_tables;
 

> >This will give you all schema-holders.
>
> What is the difference between DBA_TABLES and ALL_TABLES?
>
> --
> Keith Shave
> Management Information Services
> Ph: (204) 945-7937
> Fax: (204) 948-2542
Received on Mon Oct 19 1998 - 00:00:00 CDT