index partition and lob partition required?
After upgrade OCBRM from 7.3.1 to 7.5(DB11g), it is found that many SYS_IL0000 (INDEX PARTITION) and SYS_LOB0000 (LOB PARTITION) had been created as below.
OWNER OBJECT_NAME OBJECT_TYPE CREATED STATUS COUNT(1)
---------- ---------------------------------------- ------------------- -------------------- ------- ----------
PIN SYS_IL0000819177C00084$$ INDEX 23-FEB-2016 02:34:44 VALID 1
PIN SYS_IL0000819177C00084$$ INDEX PARTITION 23-FEB-2016 02:34:44 VALID 77
PIN SYS_LOB0000819177C00084$$ LOB 23-FEB-2016 02:34:44 VALID 1
PIN SYS_LOB0000819177C00084$$ LOB PARTITION 23-FEB-2016 02:34:44 VALID 77
They are mapped into different partitioned tablespace. We will create new partitioned tablespace manually per month.
This month, after creating the new tablespace PIN61, there is no mentioned index partition and lob partition as above.