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: John P. Higgins <jh33378_at_deere.com>
Date: 1998/10/19
Message-ID: <362BEF89.B9A7F6B1@deere.com>#1/1

DBA_TABLES is accessable only by a DBA and lists every table in the system.

ALL_TABLES lists every table that YOU own or can access through grants.

Keith S. wrote:

> "Jesper Sivertsen" <siv_at_pip.dknet.dk> writes:
>
> >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.
>
> What is the difference between DBA_TABLES and ALL_TABLES?
>
> --
> Keith Shave
> Management Information Services
> Ph: (204) 945-7937
> Fax: (204) 948-2542
Received on Mon Oct 19 1998 - 00:00:00 CDT

Original text of this message

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