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: Jesper Sivertsen <siv_at_pip.dknet.dk>
Date: 1998/10/06
Message-ID: <6vdv82$i6d$1@news.dknet.dk>#1/1

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

Original text of this message

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