if undo_managerment=auto, oracle will create the rollback segments for you named _sysmu2$ in undo_tablespace which is specified in the init.ora file. if you want to create the rollback segment by yourself, you should set undo_management to manual, and then you may issue the create rollback segment statement to create the rollback segment.
if you want to create the rollback segment by yourself, you should set undo_management to manual, and then you may issue the create rollback segment statement to create the rollback segment.
你可以建立一个增长大小不受限制的回滚段,并指定自动回缩的
缺省值(即优化值)只要回滚段使用的表空间足够大,你就不会
担心回滚段的扩展无法进行,当你建立索引的时候,指定使用你
这个回滚段就可以了。