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

try
select distinct owner
from dba_tables

logged in as ANY user with dba privilege. This will provide you with a list of users owning tables. Schema is usually nothing more or less than a user.

Hth
Sybrand Bakker, oracle dba

m.L. wrote:

> 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 Mon Oct 05 1998 - 00:00:00 CDT