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

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.

Best regards
Jesper Sivertsen

m.L. wrote in message <3618fd9a.139370888_at_news.earthlink.net>...
>Hello everyone,
>
> In one of our client databases, I need to find out the name of
>the schema in a hurry. I looked around. Apparently, user_tables has
>no such information. Should I try svrmgr?
>any help will be very much appreciated.
>
>If you don't mind, please forwar the information to
><mleung_at_intelus.com>. I will try to check this newsgroup later, but
>the sooner I get this information is better.
>
>Thanks in advance
>
>michael
Received on Tue Oct 06 1998 - 00:00:00 CDT