Static Data Dictionary Views


This is the list of the static data dictionary views that are very useful whatever you do with the schema objects and which I will refer in the posts that are coming.

VIEW NAME DESCRIPTION
USER_ALL_TABLES

describes the object tables and relational tables owned by the current user.

USER_ARGUMENTS

lists the arguments of the functions and procedures that are owned by the current user.

USER_CATALOG

lists tables, views, clusters, synonyms, and sequences owned by the current user.

USER_CLUSTERS

describes all the clusters owned by the current user.

USER_COL_COMMENTS

displays comments on the columns of the tables and views owned by the current user.

USER_COL_PENDING_STATS

describes the pending statistics of the columns owned by the current user.

USER_COL_PRIVS

describes the column object grants for which the current user is the object owner, grantor, or grantee.

USER_COL_PRIVS_MADE

describes the column object grants for which the current user is the object owner.

USER_COL_PRIVS_RECD

describes the column object grants for which the current user is the grantee.

USER_COLL_TYPES

describes named collection types (VARRAYs, nested tables, object tables, and so on) in the current user’s schema.

USER_CONS_COLUMNS

describes columns that are owned by the current user and that are specified in constraint definitions.

USER_CONS_OBJ_COLUMNS displays information about the types that object columns (or attributes) or collection elements have been constrained to, in the tables owned by the
current user.

USER_CONSTRAINTS

describes all constraint definitions on tables owned by the current user.

USER_CREDENTIALS

displays credentials owned by the current user.

USER_ENCRYPTED_COLUMNS

maintains encryption algorithm information for all encrypted columns in all tables in the user’s schema.

USER_ERRORS

describes the current errors on the stored objects owned by the current user.

USER_EXTENTS

describes the extents comprising the segments owned by the current user’s objects.

USER_EXTERNAL_LOCATIONS

describes the locations (data sources) of the external tables owned by the current user.

USER_EXTERNAL_TABLES

describes the external tables owned by the current user.

USER_FREE_SPACE

describes the free extents in the tablespaces accessible to the current user.

USER_IDENTIFIERS

displays information about the identifiers in the stored objects owned by the current user.

USER_INDEXES

describes indexes owned by the current user. To gather statistics for this view, use the DBMS_STATS package. This view supports parallel partitioned index scans.

USER_INDEXTYPES

describes the indextypes owned by the current user.

USER_INTERNAL_TRIGGERS

describes the internal triggers on all tables owned by the current user.

USER_LIBRARIES

describes the libraries owned by the current user

USER_LOB_PARTITIONS

displays the LOB partitions contained in the tables owned by the current user.

USER_LOB_SUBPARTITIONS

displays partition-level attributes of the LOB data subpartitions owned by the current user.

USER_LOBS

displays the user’s CLOBs and BLOBs contained in the user’s tables. BFILEs are stored outside the database, so they are not described by this view

USER_NESTED_TABLE_COLS

describes the columns of the nested tables owned by the current user.

USER_NESTED_TABLES

describes the nested tables in tables owned by the current user.

USER_OBJECT_TABLES

describes the object tables owned by the current user.

USER_OBJECTS

describes all objects owned by the current user.

USER_OPERATORS

describes all operators owned by the current user.

USER_PASSWORD_LIMITS

describes the password profile parameters that are assigned to the user.

USER_PLSQL_COLL_TYPES

describes the user’s own named PL/SQL collection types.

USER_PLSQL_TYPES

describes the user’s own PL/SQL types.

USER_POLICIES

describes all Oracle Virtual Private Database (VPD) security policies associated with objects owned by the current user.

USER_POLICY_ATTRIBUTES

lists the attribute associations {Namespaces, Attributes} of all context-sensitive and shared-context sensitive Oracle Virtual Private Database
(VPD) policies for synonyms, tables, or views owned by the user.

USER_POLICY_CONTEXTS

describes the driving contexts defined for the synonyms, tables, and views owned by the current user.

USER_POLICY_GROUPS

describes the policy groups defined for the synonyms, tables, and views owned by the current user.

USER_PROCEDURES

lists all functions and procedures that are owned by the current user, along with their associated properties.

USER_ROLE_PRIVS

describes the roles granted to the current user.

USER_SEGMENTS

describes the storage allocated for the segments owned by the current user’s objects.

USER_SEQUENCES

describes all sequences owned by the current user.

USER_SOURCE

describes the text source of the stored objects owned by the current user.

USER_SQLSET

displays information about the SQL tuning sets owned by the current user.

USER_SQLSET_BINDS

displays the bind values associated with the SQL tuning sets owned by the current user.

USER_STORED_SETTINGS

lists information about the persistent parameter settings for stored PL/SQL units, but only shows information about PL/SQL units owned by the
current user.

USER_SYNONYMS

describes the private synonyms (synonyms owned by the current user).

USER_SYS_PRIVS

describes system privileges granted to the current user.

USER_TAB_COLS

describes the columns of the tables, views, and clusters owned by the
current user. This view differs from “USER_TAB_COLUMNS” in that system-generated
hidden columns and invisible columns, which are user-generated
hidden columns, are not filtered out.

USER_TAB_COLUMNS

describes the columns of the tables, views, and clusters owned by
the current user. The USER_TAB_COLS view can display system-generated hidden columns and invisible
columns, which are user-generated hidden columns.

USER_TAB_COMMENTS

displays comments on the tables and views owned by the current user.

USER_TAB_PRIVS

describes the object grants for which the current user is the object owner, grantor, or grantee.

USER_TAB_PRIVS_MADE

describes the object grants for which the current user is the object owner.

USER_TAB_PRIVS_RECD

describes the object grants for which the current user is the grantee.

USER_TAB_STAT_PREFS

displays information about statistics preferences for the tables owned by the current user.

USER_TAB_SUBPARTITIONS

describes, for each table subpartition owned by the current user, the subpartition name, name of the table and partition to which it belongs, and its
storage attributes.

USER_TABLES

describes the relational tables owned by the current user.

USER_TABLESPACES

describes the tablespaces accessible to the current user.

USER_TRIGGER_COLS

describes the use of columns in the triggers owned by the current user and in triggers on tables owned by the current user.

USER_TRIGGER_ORDERING

describes the triggers owned by the current user that have FOLLOWS or PRECEDES ordering.

USER_TRIGGERS

describes the triggers owned by the current user.

USER_TYPES

describes the object types owned by the current user.

USER_UNUSED_COL_TABS

describes the tables owned by the current user that contain unused columns.

USER_UPDATABLE_COLUMNS

describes columns in a join view that can be updated by the current user, subject to appropriate privileges.

USER_USERS

describes the current user.

USER_VARRAYS

describes the varrays owned by the current user.

USER_VIEWS

describes the views owned by the current user.

USER_WALLET_ACES describes the status of access control entries for the current user to access wallets through PL/SQL network utility packages. Its columns (except for ACE_ORDER, START_DATE, END_DATE, GRANT_TYPE, INVERTED_PRINCIPAL, PRINCIPAL, PRINCIPAL_TYPE, and STATUS) are the same as those in DBA_WALLET_ACES.

I hope this will be helpful for anyone who would like to learn more about Oracle Database.

Thank you for visiting my blog!

Have a nice day!

P.S. Keep climbing Mount Olympus ( I mean keep learning and make things happen ) !

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s