O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required