创建索引失败 高手请进!help
xboy 2004-10-12 10:58:46 使用如下脚本在一个数据容量比较大的表上创建索引,失败,后面是报错。能帮我解答一下么??
sqlplus abc/abc123456 <<EOF >/dev/null
set echo off;
set feedback off;
set heading off;
set pagesize 0;
set termout off;
set trimout on;
set trimspool on;
spool builed.log;
create index smg_cdr_idx2 on smg_cdr(CreateTime)
LOCAL (
partition p1 tablespace smg_cdr_idx_1 storage(initial 20M next 20M pctincrease 0 ),
partition p2 tablespace smg_cdr_idx_2 storage(initial 20M next 20M pctincrease 0 ),
partition p3 tablespace smg_cdr_idx_3 storage(initial 20M next 20M pctincrease 0 )
);
spool off;
quit
EOF
在脚本运行一个小时左右,程序报错:
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$"
too small
回滚段错误,建立索引失败,程序退出!