ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 将表空间置为offline的参数

将表空间置为offline的参数

原创 Linux操作系统 作者:oracle_mao 时间:2011-12-20 15:03:38 0 删除 编辑

          当我们将表空间设置为offline可以选择以下参数,可在今天之前,我根本就不知道这回事~~ 

Restriction on Taking Tablespaces Offline You cannot take a temporary tablespace offline.

OFFLINE NORMAL Specify NORMAL to flush all blocks in all data files in the tablespace out of the system global area (SGA). You need not perform. media recovery on this tablespace before bringing it back online. This is the default.

OFFLINE TEMPORARY If you specify TEMPORARY, then Oracle Database performs a checkpoint for all online data files in the tablespace but does not ensure that all files can be written. Files that are offline when you issue this statement may require media recovery before you bring the tablespace back online.

OFFLINE IMMEDIATE If you specify IMMEDIATE, then Oracle Database does not ensure that tablespace files are available and does not perform. a checkpoint. You must perform. media recovery on the tablespace before bringing it back online.

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

请登录后发表评论 登录
全部评论

注册时间:2011-03-28

  • 博文量
    94
  • 访问量
    746481