Oracle 12c Data Dictionary Views

Oracle contains a wealth of information in its data dictionary views. I often find it is quicker and easier to query these views directly rather than going through a GUI in a tool like SQL developer. It is also possible to develop your own queries against these views to track conditions you care about.

 The data dictionary views are well documented by Oracle. Still though, with there being so many of them, I think it would be useful to have a quick reference to the most commonly used views. So that is what this post is all about. I've created easy to remember bit.ly links to each view, but feel free to bookmark this page as a condensed table of contents.

View Name	Documentation Link
ALL_OBJECTS	http://bit.ly/Ora12cAllObjects
ALL_TABLES	http://bit.ly/Ora12cAllTables
ALL_TAB_COLS	http://bit.ly/Ora12cAllTabCols
ALL_CONSTRAINTS	http://bit.ly/Ora12cAllConstraints
ALL_INDEXES	http://bit.ly/Ora12cAllindexes
ALL_IND_COLUMNS	http://bit.ly/Ora12cAllIndColumns