To rebuild indexes on partitions for a user in Oracle 11g run -
Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME ||';' from USER_IND_PARTITIONS;
Then run the output from that command
This is a fix for SQL Error: ORA-08102: index key not found, obj#
No comments:
Post a Comment