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

I just want to thanks everyone here for answering my question so quickly and fully. And it also helped me to understand one of the more confusing terminologies that people keep using &-)

Thanks a bunch
mike

On Tue, 6 Oct 1998 22:46:17 -0000, "Jesper Sivertsen" <siv_at_pip.dknet.dk> wrote:

>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 Wed Oct 14 1998 - 00:00:00 CDT