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

"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