CHAPTER 10
Data Dictionary Fundamentals
The previous chapters in this book focused on topics such as creating a database, strategically implementing tablespaces, managing users, basic security, tables, indexes, and constraints. In those chapters, you were presented with several SQL queries, which accessed the data dictionary views in order to
- show what users are in the database and if any of their passwords expired
- display the owners of each table and associated privileges
- show the settings of various database parameters
- determine which columns have foreign key constraints defined on them
- display tablespaces and associated data files and space ...
Get Pro Oracle Database 12c Administration, Second Edition 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.
