小弟有事求大虾啊，牛人，快来啊

ccanyi

我在oracle 9i创建回退段时，提示错误，无法在“自动还原”模式下创建军和管理回滚段，哪个牛人知道，快告诉我，谢了

1stdown

in sqlplus environment of oracle9i,
SQL>;show parameter UNDO
that will show two parameters
"UNDO_TABLESPACE" and "UNDO_MANAGEMENT"
if "UNDO_MANAGEMENT=AUTO", you can not use rollback segment mode, so you can not create the rollback segment,  you can create undo tablespace in stead of that.

if you must use the rollback segment, change parameter "UNDO_MANAGEMENT=MANUAL", and you will use it as the old mode like Oracle8i.

ccanyi

谢谢，大虾，你太牛了，别人都不知道！！！