Data Dictionary and standard Packages

Data Dictionary and standard Packages - Data Dictionary and...

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

View Full Document Right Arrow Icon
Data Dictionary and standard Packages Set of tables, set of views Contents : Logical database structure, physical structure, names-definitions-space allocation of Components: base tables, data dictionary views-catalog.sql @d:\ora81\rdbms\admin\catalog; USER VIEWS, DBA VIEWS, ALL_VIEWS dba_users, dba_sys_privs, dba_roles- User privileges and roles dba_tables, dba_objects, dba_lobs, dba_constaints- information about objects dictionary, dict_columns- General overview dba_extents, dba_segments, dba_free_space- space allocation for database objects dba_tablespaces, dba_datafiles, dba_rollback_segs- general database structures SELECT * FROM dictionary;, SELECT * FROM dictionary, SELECT segment_name FROM dba_rollback_segs; Catproc.sql creates PL/SQL functionality @d:\ora81\rdbms\admin\catproc; Utl*sql- creates additional views and tables for database utilities. Cat*.sql- creates data dictionary views and catalog tables for a database.
Background image of page 1

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

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

Page1 / 2

Data Dictionary and standard Packages - Data Dictionary and...

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

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