首页 > 应用开发 > IT综合 > Introduction to the Data Dictionary (257)

Introduction to the Data Dictionary (257)

原创 IT综合 作者:tsinglee 时间:2007-11-28 10:31:24 0 删除 编辑

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
■ The definitions of all schema objects in the database (tables, views, indexes,
clusters, synonyms, sequences, procedures, functions, packages, triggers, and so
■ 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
■ Auditing information, such as who has accessed or updated various schema
■ Other general database information
The data dictionary is structured in tables and views, just like other database data. All
the data dictionary tables and views for a given database are stored in that database’s
SYSTEM tablespace.

Not only is the data dictionary central to every Oracle database, it is an important tool
for all users, from end users to application designers and database administrators. Use
SQL statements to access the data dictionary. Because the data dictionary is read only,
you can issue only queries (SELECT statements) against it’s tables and views.

1. 数据字典包含以下信息:所有方案对象的定义,空间分配及使用情况,列的默认值,完整性约束等
2. 数据字典是只读的


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

  • 博文量
  • 访问量