introduction to tablespaces, datafiles, and control files(34)-优快云博客

本文介绍了Oracle数据库的基本结构，包括数据库、表空间和数据文件之间的关系。数据库由一个或多个表空间组成，每个表空间包含一个或多个数据文件，这些文件在操作系统中具有特定的物理结构。

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

oracle stores data logically in tablespaces and physically in datafiles associated with
the corresponding tablespace.
datafiles objects(physical structures associated with only one tablespace)
objects (stored in tablespaces-may span several datafiles)
databases, tablespaces, and datafiles are closely related, but they have important differences:
1 an oracle database consists of one or more logical storage units called tablespaces,
which collectively store all of the database??s data.
2 each tablespace in an oracle database consists of one or more files called datafiles,
which are physical structures that conform to the operating system in which
oracle is running.
3 a database??s data is collectively stored in the datafiles that constitute each
tablespace of the database.

1. 数据文件和表空间是1对1
2. 对象存储在表空间，可能跨越多个数据文件
3. 数据库由或多或少的表空间组成（逻辑对象）
conform to 符合, 遵照

[@more@]

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

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