Overview of Datafiles (62)

最新推荐文章于 2025-12-14 11:16:01 发布

转载最新推荐文章于 2025-12-14 11:16:01 发布 · 85 阅读

文章标签：

#数据库

本文介绍了Oracle数据库中表空间的概念及数据文件的作用。每个表空间由一个或多个物理数据文件组成，而每个数据文件只能属于一个表空间和一个数据库。文章还详细解释了数据文件创建的过程以及操作系统如何为Oracle分配文件。

A tablespace in an Oracle database consists of one or more physical datafiles. A
datafile can be associated with only one tablespace and only one database.
Oracle creates a datafile for a tablespace by allocating the specified amount of disk
space plus the overhead required for the file header. When a datafile is created, the
operating system under which Oracle runs is responsible for clearing old information
and authorizations from a file before allocating it to Oracle. If the file is large, this
process can take a significant amount of time. The first tablespace in any database is
always the SYSTEM tablespace, so Oracle automatically allocates the first datafiles of
any database for the SYSTEM tablespace during database creation.[@more@]

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

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