Saturday, March 1, 2014

Weekend Learning: Oracle Data Dictionary

This likely will be old hat to many out there in the community, but I found note 1500058.1 in My Oracle Support that deserves a good viewing if you're new to looking for information related to Oracle database and application technology.  Titled "Master Note: Overview of Oracle Data Dictionary" it goes over the difference between the views that are prefixed with ALL_, DBA_, and USER_ plus teaches us about the view DICTIONARY which lists all views in the data dictionary.

For more advanced individuals, this note also has several interesting tidbits about the O7_DICTIONARY_ACCESSIBILITY parameter as well as a change in 12c to the SELECT ANY DICTIONARY privilege which limits access to several items so they are no longer able to be viewed.

No comments:

Post a Comment