Sunday, August 24, 2014

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

2 comments:

  1. I agree with Dev - I think they need an update :) I'm not an oracle specialist, or any IT-stuff-related-specialist at all, but I made the decision that my company needs something fresh. And by saying 'something', I mean software from https://ax-dynamics.com/! :)

    ReplyDelete