ITPub博客

首页 > 数据库 > Oracle > oralce 9i&10g切换undo tablespace 步骤

oralce 9i&10g切换undo tablespace 步骤

原创 Oracle 作者:cyr1974 时间:2007-05-01 17:10:50 0 删除 编辑

select * from v$tablespace

create undo tablespace undotbs01 datafile '/oradata/rdev/undotbs01.dbf' size 2000m autoextend on

/* Formatted on 2007/05/01 17:04 (Formatter Plus v4.8.8) */
SELECT a.usn, a.status, b.tablespace_name, b.segment_name
FROM v$rollstat a, dba_rollback_segs b
WHERE a.usn = b.segment_id

alter system set undo_tablespace=undotbs01 scope=both

SELECT a.usn, a.status, b.tablespace_name, b.segment_name
FROM v$rollstat a, dba_rollback_segs b
WHERE a.usn = b.segment_id

alter tablespace undotbs2 offline

alter tablespace undotbs2 online

alter tablespace undotbs2 offline

drop tablespace undotbs2 including contents

delete the datafile from os

[@more@]

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

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

注册时间:2009-03-16

  • 博文量
    37
  • 访问量
    256947