Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to find the name of the schema on an existing Oracle 7 Database?

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1998/10/05
Message-ID: <36192880.8E9663A3@sybrandb.demon.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US