Why index needs to be dropped and recreated?
The table was purged using the below command :
alter table <table_name> truncate partition <partition_name> drop storage update indexes parallel 6;
After the purge, the following error was encountered:
ORA-01410: invalid ROWID
After investigation from the application logs we found 2 tables for which we dropped and recreate the indexes and after that it was fine. Also note that all the related indexes were valid before and after purging activity.
Need to know why the indexes have to be dropped and recreated? The indexes were in valid state before and after purging.
alter table <table_name> truncate partition <partition_name> drop storage update indexes parallel 6;
After the purge, the following error was encountered:
ORA-01410: invalid ROWID
After investigation from the application logs we found 2 tables for which we dropped and recreate the indexes and after that it was fine. Also note that all the related indexes were valid before and after purging activity.
Need to know why the indexes have to be dropped and recreated? The indexes were in valid state before and after purging.
0