0 Replies Latest reply on Sep 9, 2012 1:36 PM by 877440

    partition index tablespace kept growing, how to look at this?

      Oracle version is 11gr1, os is aix.

      We have a 100 tb dataware house, tables are partitioned including indexes.

      Every table drop data 6 month ago, and same with index. However our table tablespace did not see growing, but index tablespace kept growing, I have to keep adding spaces.

      HOw to look at this? where to find the problem is?

      Thanks in advance.