How to delete duplicate keys from partition table
Hi,
we got the error while data transform is happen from Production to Test
ORA-01502: index 'DS_SBT.DS_SBT_PD_SUM_PK' or partition of such index is in unusable state
I checked the table last partition is unusable state.So I tried to rebuild the index partition.but i got the below error.
SQL> alter index DS_SBT.DS_SBT_PD_SUM_PK rebuild partition P_MAX tablespace DS_PK_SBT_SUM;
alter index DS_SBT.DS_SBT_PD_SUM_PK rebuild partition P_MAX tablespace DS_PK_SBT_SUM
*
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
we got the error while data transform is happen from Production to Test
ORA-01502: index 'DS_SBT.DS_SBT_PD_SUM_PK' or partition of such index is in unusable state
I checked the table last partition is unusable state.So I tried to rebuild the index partition.but i got the below error.
SQL> alter index DS_SBT.DS_SBT_PD_SUM_PK rebuild partition P_MAX tablespace DS_PK_SBT_SUM;
alter index DS_SBT.DS_SBT_PD_SUM_PK rebuild partition P_MAX tablespace DS_PK_SBT_SUM
*
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
0