Tablespaces, Datafiles, and Control Files

最新推荐文章于 2023-03-02 21:00:00 发布

ygzn_5118

最新推荐文章于 2023-03-02 21:00:00 发布

阅读量604

点赞数

本文链接：https://blog.youkuaiyun.com/ygzn_5118/article/details/19398619

版权

本文介绍了Oracle数据库中表空间和控制文件的重要概念。对于表空间，文章解释了当SYSTEM表空间为本地管理时，必须定义至少一个默认临时表空间，并且不能用于默认临时存储；此外还说明了在这种情况下无法创建字典表空间。关于控制文件，则详细列出了其包含的各种信息，如数据库名称、创建时间戳、数据文件和重做日志文件的位置等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--Tablespaces

1.When the SYSTEM tablespace is locally managed, you must define at least one default temporary tablespace when creating a database. A locally managed SYSTEM tablespace cannot be used for default temporary storage.

2.In a database with a locally managed SYSTEM tablespace, dictionary tablespaces cannot be created. It is possible to plug in a dictionary managed tablespace using the transportable feature, but it cannot be made writable

--Control Files

Among other things, a control file contains information such as:
■ The database name
■ The timestamp of database creation
■ The names and locations of associated datafiles and redo log files
■ Tablespace information
■ Datafile offline ranges
■ The log history
■ Archived log information
■ Backup set and backup piece information
■ Backup datafile and redo log information
■ Datafile copy information
■ The current log sequence number
■ Checkpoint information