我在ORACLE10G,用SYS用户,用以下语句创建回滚段:
CREATE ROLLBACK SEGMENT RB02
TABLESPACE USERS
STORAGE (
INITIAL 100K
NEXT 100K
MINEXTENTS 20
MAXEXTENTS 100
OPTIMAL 2000K );创建成功了,但用 select segment_id,segment_name from dba_rollback_segs语句查不到
CREATE ROLLBACK SEGMENT RB02
TABLESPACE USERS
STORAGE (
INITIAL 100K
NEXT 100K
MINEXTENTS 20
MAXEXTENTS 100
OPTIMAL 2000K );创建成功了,但用 select segment_id,segment_name from dba_rollback_segs语句查不到
值是auto吧
CREATE TABLESPACE rbs_ts
DATAFILE 'rbs01.dbf' SIZE 10M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100K;/* This example and the next will fail if your database is in
automatic undo mode.
*/
CREATE ROLLBACK SEGMENT rbs_one
TABLESPACE rbs_ts;
是auto,那auto会怎么样呢?这方面不是很清楚。。难道我不可以自己创建一个回滚段吗?