What are the categories of data dictionary views?
What are the categories of data dictionary views?
Rating:
The Oracle data dictionary has three main sets of data dictionary views (also known as static data dictionary views). Each set of views is distinguished from others by its scope and prefix.
Data dictionary views with USER_ prefixes display information about database structures owned by the current user. These views are accessible to all users. These views do not possess the OWNER column. The OWNER column is implied to be the current user. Public synonyms can be created for these data dictionary views.
Data dictionary views with ALL_ prefixes display information about the database structures that are accessible to the current user, whether or not the user owns the database structures. These views are also accessible to all users. These views possess the OWNER column. These views can also have public synonyms.
Data dictionary views with DBA_ prefixes display information about all database structures in a database. These views are accessible only to database administrators or users with the SELECT ANY TABLE or SELECT ANY DICTIONARY privilege. These views also possess the OWNER column. Public synonyms cannot be created for these views.
All data dictionary views and their corresponding base tables are stored in the SYSTEM tablespace and owned by the SYS schema. The contents of the base tables are automatically updated by Oracle, and they cannot be manually altered.
Rating:
Other articles
- What are PCTFREE and PCTUSED parameters?
- What is a password file?
- What is Oracle's account locking feature?
- What is instance recovery?
- What is a database template?
