C H A P T E R 10
Data Dictionary Basics
The previous chapters in this book focus on topics such as managing users, basic security, tables, indexes, and constraints. This chapter focuses on extracting information from the data dictionary regarding those topics. Each of the sections in this chapter contains one or more SQL queries that demonstrate how to extract information from the data dictionary regarding a specific type of database object.
The Oracle data dictionary houses information about all aspects of the database. It stores critical information about the physical characteristics of the database, users, objects, and dynamic performance ...
Get Pro Oracle Database 11g Administration 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.
