我的表中有2.7亿条记录，分成183个分区，我昨天truncate一个分区后，在插入数据报错ORA-01502: index 'INDX_JIAOYSJ01' or partition of such index is error，发现这个表的一个索引被破坏，提示需要重建这个索引，这个索引有一个字段10个字节，我重建时又报错ORA-01652: unable to extend temp segment by 640 in tablespace TEMP_APP01，提示临时表空间不够，需要增加，结果我由原来的900M增加到现在的7.4G，却还是报错ORA-01630: max # extents (805) reached in temp segment in tablespace TEMP_APP01，
请问高手有什么更好的办法？或者如何计算这个临时表空间的大小？我已经从昨天下午4:00整到现在了，哭……
ORA-01502 index 'string.string' or partition of such index is in unusable state
Cause: An attempt has been made to access an index or index partition that has
been marked unusable by a direct load or by a DDL operation.
Action: DROP the specified index, or REBUILD the specified index, or
REBUILD the unusable index partition.
ORA-01630: max # extents (string) reached in temp segment in tablespace string
Cause: A temporary segment tried to extend past MAXEXTENTS.
Action: If MAXEXTENTS for the tablespace is less than the system maximum, you can raise that. Otherwise, raise PCTINCREASE for the tablespace.
