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 |
| 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 |
| 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 |
| 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 ) !
Climbing Olympus 