ITPub博客

首页 > 应用开发 > IT综合 > The SYSTEM Tablespace (39)

The SYSTEM Tablespace (39)

原创 IT综合 作者:tsinglee 时间:2007-09-26 15:26:55 0 删除 编辑

Every Oracle database contains a tablespace named SYSTEM, which Oracle creates
automatically when the database is created. The SYSTEM tablespace is always online
when the database is open.
To take advantage of the benefits of locally managed tablespaces, you can create a
locally managed SYSTEM tablespace, or you can migrate an existing dictionary
managed SYSTEM tablespace to a locally managed format.
In a database with a locally managed SYSTEM tablespace, dictionary managed
tablespaces cannot be created. It is possible to plug in a dictionary managed tablespace
using the transportable feature, but it cannot be made writable.

The Data Dictionary
The SYSTEM tablespace always contains the data dictionary tables for the entire
database. The data dictionary tables are stored in datafile 1.

PL/SQL Program Units Description
All data stored on behalf of stored PL/SQL program units (that is, procedures,
functions, packages, and triggers) resides in the SYSTEM tablespace. If the database
contains many of these program units, then the database administrator must provide
the space the units need in the SYSTEM tablespace.

1. 数据库打开时 , 总是在线
2. 当system表空间为本地管理时 , 不能创建字典管理表空间
3. 数据字典保存在数据文件1
4. 注意保证system表空间有足够的空间

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-972492/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892957