【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“13.7.sql”一文,供大家参考学习
--将自动撤销管理模式迁移到手动管理的模式
--1.查看当前数据库中撤销表空间的信息
show parameter undo
--2.关闭数据库,修改相关的初始化参数的值
--undo_management='auto'
--undo_tablespace='undotbs1'
--3. 创建SPFILE文件,重启数据库实例
create spfile form pfile;
startup
--4.创建一个新的撤销表空间及回滚段.
create udno tablespace undotbs2
datafile 'path' size 10M
autoextend on;
create public rollback segment rbs01 tablespace undotbs2;
create public rollback segment rbs02 tablespace undotbs2;
create public rollback segment rbs03 tablespace undotbs2;
create public rollback segment rbs04 tablespace undotbs2;
create public rollback segment rbs05 tablespace undotbs2;
create rollback segment rbs06 tablespace undotbs2;
create rollback segment rbs07 tablespace undotbs2;
create rollback segment rbs08 tablespace undotbs2;
create rollback segment rbs09 tablespace undotbs2;
create rollback segment rbs10 tablespace undotbs2;
alter rollback segment rbs01 online;
alter rollback segment rbs02 online;
alter rollback segment rbs03 online;
alter rollback segment rbs04 online;
alter rollback segment rbs05 online;
alter rollback segment rbs06 online;
alter rollback segment rbs07 online;
alter rollback segment rbs08 online;
alter rollback segment rbs09 online;
alter rollback segment rbs10 online;
--5.关闭数据库,修改初始化参数文件,使私有回滚段在启动时自动联机
--rollback_segments=('rbs06','rbs07','rbs08','rbs09','rbs10')
--6.创建SPFILE,重启数据库实例,使私有的回滚段自动联机
select segment_name,tablespace_name,status
from dba_rollback_segs
where segment_name like 'RBS%';