Re: index creation fails because temp tablespace is too small

Hi, Chao,

Data Warehousing Guide talks about the two granule strategies, block range granules (based on rowids; we also see the term "rowid range granules" in x$ksppi description) and partition granules (based on partitions). Oracle says "There is no way you can enforce a specific granule strategy as Oracle Database makes this decision internally." But the text seems to suggest that block range granules are used in most cases, while partition granules are used in "parallel index range scans and of parallel operations that modify multiple partitions of a partitioned table or index. These operations include parallel creation of partitioned indexes, and parallel creation of partitioned tables."

Yong Huang Received on Sat Apr 30 2005 - 23:49:03 CDT