Datafile Contents (63)

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

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

文章标签：

#数据库

本文介绍了Oracle数据库中数据文件的创建与使用过程。当数据文件首次创建时，Oracle会预留空间用于存放未来表空间段的数据。随着数据增长，Oracle会在相关数据文件中分配区段以满足需求。需要注意的是，模式对象并不对应特定的数据文件，而是分布在表空间内的一个或多个数据文件中。

When a datafile is first created, the allocated disk space is formatted but does not
contain any user data. However, Oracle reserves the space to hold the data for future
segments of the associated tablespace—it is used exclusively by Oracle. As the data
grows in a tablespace, Oracle uses the free space in the associated datafiles to allocate
extents for the segment.
The data associated with schema objects in a tablespace is physically stored in one or
more of the datafiles that constitute the tablespace. Note that a schema object does not
correspond to a specific datafile; rather, a datafile is a repository for the data of any
schema object within a specific tablespace. Oracle allocates space for the data
associated with a schema object in one or more datafiles of a tablespace. Therefore, a
schema object can span one or more datafiles. Unless table striping is used (where
data is spread across more than one disk), the database administrator and end users
cannot control which datafile stores a schema object.[@more@]

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

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