Contents

Oracle Dictionary Views

Depending on your role you have more or less rights to see the systems objects in order to diagnose problems. You should always start with ALL* views which

ALL Views

Description of all objects and relational tables accessible to the user .
To find out what is there for you to see start with:
 select * from ALL_VIEWS where view_name like 'ALL%';

Example:
ALL_ALL_TABLES
Description of all object and relational tables accessible to the user

 select * from ALL_TABLES where table_name like '%MYTAB%';

DBA Views

Description of all objects and relational tables accessible to the DBA .
To find out what is there for you to see start with:
 select * from DBA_VIEWS where view_name like 'DBA%';

 select * from dba_views where view_name like '%TAB%'

DBA_ALL_TABLES
Description of all object and relational tables in the database

DBA_OBJECTS
All objects in the database

 select * from DBA_SEGMENTS where segment_name like '%MYTAB%';

USER Views

Shows the users own objects
USER_TABLES
Description of the user's own relational tables


Here are some of the dictionary views are available for DBAs



See Also:
Oracle-Dictionary-Views

Status: Draft Date: 2014-10-15 00:23:19 +0200 (Mi, 15 Okt 2014) Revision: 27

Copyright bei Andreas Haack (C) 2014. Diese Seite wird so wie sie ist zur Verfuegung gestellt, ohne irgenweche Garantien der Verwendbarkeit fuer bestimte Zwecke. Die auf dieser Seiten angebrachten Links liegen ausserhalb der redaktionellen Verantwortung von Andreas Haack und es wird keine Haftung oder Garantie uebernommen. Die Seiten sind Copyright (c) 2014 von Andreas Haack. Kein Teil darf ohne die schriftliche Einverstaendnis von Andreas Haack veroeffentlicht werden.
The page is provided 'as is' , without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fit- ness for a particular purpose and non-infringement. In no event shall Andreas Haack be liable for any claim, damages or other liability. This page is copyrighted property of Andreas Haack. Copyright by Andreas Haack (c) 2014 . No part of this page may be published without written permission for Andreas Haack. A hyper-link may created to this page but NOT to the embedded elements of this page. It may be freely downloaded for private purpose only as long as it is unaltered.