有个分区表用时间做范围分区,该字段同时是bitmap索引。做表分析时,报错!
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "GSM_ETL.GSM_GATHER_TABLE", line 1668
ORA-20000: index "GSM_ETL"."GSM_PM_NETSGROUP_H_IDX1" or partition of such index is in unusable state
ORA-06512: at line 1
看了看错误,貌似是索引字段引起的。于是试着重建索引
ALTER INDEX GSM_PM_NETSGROUP_H_IDX1 REBUILD PARTITION PART_DTM_REPDATE_2012;
报错,说该分区不存在。语句应该没有错吧!(谁能解释一下)
由于问题比较急着解决
就把索引删了,重建了一下!
drop index GSM_PM_NETSGROUP_H_IDX1;
create bitmap index GSM_PM_NETSGROUP_H_IDX1 on GSM_PM_NETSGROUP_H (dtm_repdate) local;
分析不报错了!
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "GSM_ETL.GSM_GATHER_TABLE", line 1668
ORA-20000: index "GSM_ETL"."GSM_PM_NETSGROUP_H_IDX1" or partition of such index is in unusable state
ORA-06512: at line 1
看了看错误,貌似是索引字段引起的。于是试着重建索引
ALTER INDEX GSM_PM_NETSGROUP_H_IDX1 REBUILD PARTITION PART_DTM_REPDATE_2012;
报错,说该分区不存在。语句应该没有错吧!(谁能解释一下)
由于问题比较急着解决
就把索引删了,重建了一下!
drop index GSM_PM_NETSGROUP_H_IDX1;
create bitmap index GSM_PM_NETSGROUP_H_IDX1 on GSM_PM_NETSGROUP_H (dtm_repdate) local;
分析不报错了!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26940217/viewspace-732687/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26940217/viewspace-732687/