4-Data Dictionary Contents (2)

4-Data Dictionary Contents (2) - ata Dictionary Contents...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ata Dictionary Contents Tathagata Bhattacharjee Data Dictionary Contents Presenter Tathagata Bhattacharjee ata Dictionary Contents Tathagata Bhattacharjee Objectives After completing of this lesson you would be able to do the following: Identify key data dictionary components Identify the contents and uses of the data dictionary Query the data dictionary ata Dictionary Contents Tathagata Bhattacharjee Data Dictionary The data dictionary is a set of read-only tables and views that record, verify and provide information about its associated database It describes the database and its objects Includes two types of objects Base Tables Data Dictionary views ata Dictionary Contents Tathagata Bhattacharjee Base Tables Stores information about the database These are the first objects created in any Oracle database These are automatically created when Oracle server runs the sql.bsq script at the time of database creation Only Oracle server can write to these tables ata Dictionary Contents Tathagata Bhattacharjee Users rarely access these tables as most of the data is stored in a cryptic format Never use DML statements directly to update the base tables E.g. IND$ is a base table which contains information about the indexes in the database ata Dictionary Contents Tathagata Bhattacharjee Data Dictionary Views Summarizes base table information This helps in displaying base table information in a more useful manner For example, in data dictionary views, objects names are used instead of only the object number The data dictionary views are created using catalog.sql script ata Dictionary Contents Tathagata Bhattacharjee Data Dictionary Contents The definition of all schema objects in...
View Full Document

Page1 / 23

4-Data Dictionary Contents (2) - ata Dictionary Contents...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online