1. 设置五个回滚段的sql语句如下：
select segment_name from dba_rollback_segs where initial_extent < 512000 and
uppper(owner) = 'public';
select upper(status) from dba_rollback_segs where upper(segment_name) = ''
alter rollback segment rb1 offline;
alter rollback segment rb2 offline;
alter rollback segment rb3 offline;
alter rollback segment rb4 offline;
alter rollback segment rb5 offline;
drop rollback segment rb1;
drop rollback segment rb2;
drop rollback segment rb3;
drop rollback segment rb4;
drop rollback segment rb5;
create public rollback segment rb1 tablespace rollback_data
storage (initial 512000 next 512000 maxextents 121);
create public rollback segment rb2 tablespace rollback_data
storage (initial 512000 next 512000 maxextents 121);
create public rollback segment rb3 tablespace rollback_data
storage (initial 512000 next 512000 maxextents 121);
create public rollback segment rb4 tablespace rollback_data
storage (initial 512000 next 512000 maxextents 121);
create public rollback segment rb5 tablespace rollback_data
storage (initial 512000 next 512000 maxextents 121);
alter rollback segment rb1 online;
alter rollback segment rb2 online;
alter rollback segment rb3 online;
alter rollback segment rb4 online;
alter rollback segment rb5 online;
commit; 2.将数据量大的库存表等放在一簇内的sql语句如下：
kcb='create table qc_kcb( '
+' cknm number(8) ,'
+' qcnm number(10) ,'
+' ckkc number(12,2),'
+' snckkc number(12,2),'
+' ldj number(12,2),'
+' bz varchar(100),'
+' primary key(cknm,qcnm))'
+' tablespace wxgl_data1 ' ;（大数据量的库存表等放在wxgl_data1)
qcfl = 'create table qc_qcfl '
+ '(flbh number(2) primary key,'
+ ' flmc varchar(20) '
+ ' ) '
+' tablespace wxgl_data2 ' ;(其他表放在wxgl_data2） |
