Exploring the static data dictionary views
Static data dictionary views are the set of views so named due to their infrequently changing nature. Static data dictionary views are not truly static; rather, they are comparatively slow changing compared to the dynamic data dictionary views. There are three basic types of static data dictionary views, and these are differentiated by their prefixes, USER_, ALL_, and DBA_.
Static data dictionary views prefixed with USER_ are those whose subject pertains to the ownership of the user itself. For example, if we were logging in to the database with our companylink user and query the USER_TABLES view, we would see all of the tables owned by our current user companylink. If we query from USER_INDEXES, we ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.
