Home -> Usenet -> comp.databases.oracle -> Re: Table names

Re: Table names

From: Bob Poortinga <bobp_at_tsc.com>
Date: 1996/07/18
Message-ID: <31EEA633.7A4A_at_tsc.com>#1/1 








Barbara Hiles <BEH_at_csd.uwm.edu> writes:
 


> Is there a table to list or a place in documentation that lists all of the

> Oracle tables?  System tables and user tables?  I know of dba_tables and


> user_tables.  I'm looking for a list of the tables like dba_tables, roles, etc.





Objects such as 'dba_tables' & 'dba_roles' are VIEWS on the underlying SYS.* tables;
So look in 'dba_views' for them.  For an all inclusive listing of everything
in the database, look in 'dba_objects'.


--
Bob Poortinga (mailto: bobp_at_tsc.com)
Technology Service Corp. (http://www.tsc.com)
Bloomington, Indiana  USA


Received on Thu Jul 18 1996 - 00:00:00 CEST












Original text of this message