Overview of Datafiles (62)

tsinglee發表於2007-10-16
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章