Hi All,
I have a table with composite primary key as (Dept_id,ref_num).
This table has 3 partitions on column trans_dt which has data in format "mon2016" and each partition has 5 sub-partitions on column dept_id.
whenever i truncate a specific partition and again insert the data in the same table then i get error: ORA-01502: index <index_name> or partition of such index is in unusable state
what's the reason for this error?
DB version is 11.2.0.3