0 Replies Latest reply: Sep 9, 2012 8:36 AM by 877440 RSS

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

    877440
      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.