Oracle Shooter

Structure of metadata and how to use metadata structure in Oracle database —-How to Use the Data Dictionary (Metadata) —- The views of the data dictionary serve as a reference for all database users.  Access the data dictionary views with SQL statements.  Some views are accessible to all Oracle users, and others are intended for database administrators only. The data dictionary consists of sets of views. In many cases, a set consists of three views  containing similar information and distinguished from each other by their prefixes: Prefix Scope USER :- User’s view (what is in the user’s schema) ALL  :- Expanded user’s view (what the user can access) DBA  :- Database administrator’s view (what is in all users’ schemas) 1. Views with the Prefix USER ——— The views most likely to be of interest to typical database users are those with the prefix USER. These views: Refer to the user’s own private environment in the database,  including information about schema objects created by the user, 

Metadata What is Metadata in Oracle and What is Data Dictionary | Oracle Shooter –Definition —  The Oracle data dictionary is one of the most important components of the Oracle DBMS.  It contains all information about the structures and objects of the database  such as. • tables, • columns, • users, • data files etc.  The data stored in the data dictionary are also often called metadata. –Introduction to the Data Dictionary One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables that provides information about the database. A data dictionary contains: The definitions of all schema objects in the database (tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers, and so on) How much space has been allocated for, and is currently used by, the schema objects Default values for columns Integrity constraint information The names of Oracle users Privileges and roles each user has been granted Aud