The SYSTEM Tablespace (39)

最新推荐文章于 2025-12-15 21:10:21 发布

转载最新推荐文章于 2025-12-15 21:10:21 发布 · 137 阅读

文章标签：

本文介绍了Oracle数据库中自动创建的SYSTEM表空间，该表空间始终在线且包含整个数据库的数据字典表格。文章还讨论了SYSTEM表空间的管理方式，包括本地管理和字典管理的区别，并提到了如何迁移现有的字典管理的SYSTEM表空间到本地管理格式。

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-972492/