ITPub博客

首页 > 应用开发 > IT综合 > introduction to tablespaces, datafiles, and control files(34)

introduction to tablespaces, datafiles, and control files(34)

原创 IT综合 作者:tsinglee 时间:2007-09-25 17:23:05 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 中秋佳节
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892893