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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.