How to get rid of 2 objects after failed online re-indexing
648880Jul 8 2008 — edited Jul 8 2008Hi,
I wonder if anyone has encountered this or knows what to do with two remaining objects that originates from a failed index rebuild.
There was an attempt to rebuild indexes online and for some reason with following error:
########################################
ALTER INDEX ODS.RP_DN
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00933: SQL command not properly ended
########################################
After the attempt there are the following objects left behind:
- index SYS_IOT_TOP_5285
- table SYS_JOURNAL_4927
I'm not sure whether it is safe to just drop these two objects or not? I tried to rename both of them, but was not able to rename the index:
############################################
alter index ODS.SYS_IOT_TOP_5285 rename to OLD_SYS_IOT_TOP_5285
*
ERROR at line 1:
ORA-25176: storage specification not permitted for primary key
##############################################
So if anyone has any knowledge on this, it would be much appreciated.