Dictionary

These views provide information about the objects in the data dictionary:

DBA_CATALOG

Lists all tables, views, sequences, and synonyms in the database.

DBA_DEPENDENCIES

Lists dependencies between database objects. Used to determine which objects become invalid after other objects are altered or dropped.

DBA_OBJECTS

Lists all objects in the database. Note that this name predates the Objects Option and is not restricted to objects created using the Objects Option.

DICT_COLUMNS

Lists all columns defined in the data dictionary views.

DICTIONARY

Lists all data dictionary views.

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.