Oracle8i回滚段表空间的坏块

核心提示： 31 rows selected.把initial_extent,next_extent,min_extents,max_extents,pct_increase的值都记录下来，留做以后创建新的回滚段使用，Oracle8i回滚段表空间的坏块(4)，创建LMT管理方式的回滚段表空间(我的数据

31 rows selected.

把initial_extent,next_extent,min_extents,max_extents,pct_increase的值都记录下来，留做以后创建新的回滚段使用。

创建LMT管理方式的回滚段表空间(我的数据库是oracle817):

SQL> create tablespace
rbs01 datafile '/opt/oracle/db02/oradata/ORCL/rbs01.dbf'
size 1024M?autoextend on next 1M maxsize unlimited extent
management local;
Tablespace created.

先在该表空间下建立一个回滚段rbs31做一个测试:

SQL> create public rollback segment RBS31 tablespace rbs01
storage(initial
524288
next 524288 MINEXTENTS 8 MAXEXTENTS 4096 OPTIMAL 4194304);
create public rollback segment RBS31 tablespace rbs01
storage(initial
524288 next
524288 MINEXTENTS 8 MAXEXTENTS 4096 OPTIMAL 4194304)
*
ERROR at line 1:
ORA-25151: Rollback Segment cannot be created in this tablespace

出现上例说明出错了，没有立建成功。

这说明对于oracle8i来讲在LMT方式管理的表空间下不能创建回滚段，但9i解决了该问题。

metalink上的解释:

Explanation
-----------
Rollback segments cannot be created in locally
managed tablespaces (a new feature in Oracle 8.1) with allocation
typeof AUTOALLOCATE. They must be created in locally managed
tablespaces with allocation type of UNIFORM or in
dictionary managed tablespaces.
NOTE: This restriction has been lifted in Oracle