过着简单,真实的生活，喜欢收藏变形金刚(TFE,G1,SL系列)，研究金融股市，KOF98，篮球，学习研究Oracle技术,我并不是一个全职的Oracle DBA，但是对于Oracle技术的热爱和研究，是一个不争的事实，愿意结交广大Oracle技术爱好者！MSN:oracle_kof_tf@hotmail.com
tablespace offline和datafile offline的区别
上一篇 /
下一篇 2008-02-01 17:39:57
/ 个人分类：Oracle数据库技术-数据库管理
There is a big difference between:
Taking the tablespace offline and Taking the datafiles offline
ALTER TABLESPACE ... OFFLINE
Does a checkpoint on the datafiles
Takes the datafiles offline
ALTER DATABASE DATAFILE ... OFFLINE
Does not perform. a checkpoint,
So that if the database is open, you may need to perform. media recovery when bringing it online.
That is the reason why:
You cannot do 'alter database datafile ... offline' if you are in noarchivelog (but tablespace offline works)
You cannot do 'alter tablespace ... offline' if database is read-only (but datafile offline works)
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
