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@]
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博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-976979/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002864
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
