ORA-02475: maximum cluster chain block count of 65534 has been exceeded

郑全

数据库报警文件不停的报以下错误：
    ORA-02475: maximum cluster chain block count of 65534has been exceeded


可以通过重建 smon_scn_time 来解决
具体步骤见：
    shutdown immediate
    startup upgrade;
    rename smon_scn_time to smon_scn_time_org;
    create table smon_scn_time tablespace sysaux as select * from smon_scn_time_org;
    drop index smon_scn_time_tim_idx;
    create unique index smon_scn_time_tim_idx on smon_scn_time(time_mp) tablespace SYSAUX;
    drop index smon_scn_time_scn_idx;
    create unique index smon_scn_time_scn_idx on smon_scn_time(scn) tablespace SYSAUX;

具体参见：mos 2389804.1