This discussion is archived
0 Replies Latest reply: Sep 9, 2012 6:36 AM by user301176 RSS

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

user301176 Explorer
Currently Being Moderated
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points