2012-07-19 ORA-1652: unable to extend temp segment

http://www.itpub.net/thread-1144914-1-1.html

Q:数据表空间报ORA-1652: unable to extend temp segment by 8 in tablespace ...
报的表空间不是临时表空间,是数据表空间
用户也没有把此数据表空间用做临时表空间


A:when you create a new segment (i.e. building an index), Oracle uses temporary extents
to initially build it and then at the end of the process -- converts (via a simple dictionary update) the extents
into permanent ones.

It does this so that if the instance crashed 1/2 the way through the index rebuild, SMON
would find the temporary extents out there and clean them up -- nothing special needs to
be done.

So, these "temporary" extents are really your INDEX extents and this message is saying
"sorry, insufficient space to create your index in this tablspace"

Add more space to the tablespace so it can hold the index.

--Tom K.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24383181/viewspace-735985/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24383181/viewspace-735985/