Performing the mailarchive long->clob conversion results in invalid/unusable indexes (ORA-01502)
GENERAL
TESTING
GENERAL
TESTING
Description
This will mostly be a release documentation issue related to the fix for to convert the long to clob. Still seems useful incase it comes up again.
– Detect and repair indexes in an invalid state ORA-01502 – Run this select, it there are any problems with the indexes, run the alter index statements that it generates.
select 'alter index '||index_name||' rebuild online;' from user_indexes where status = 'INVALID' or status = 'UNUSABLE';
– After this you may need to re-gather table stats on the tables with an invalid index (likely just mailarchive)
Collect stats using "analyze table /your_table_name/ compute statistics;' or DBMS_STATS.gather_tables_stats();
This will mostly be a release documentation issue related to the fix for to convert the long to clob. Still seems useful incase it comes up again.
– Detect and repair indexes in an invalid state ORA-01502
– Run this select, it there are any problems with the indexes, run the alter index statements that it generates.
select 'alter index '||index_name||' rebuild online;' from user_indexes where status = 'INVALID' or status = 'UNUSABLE';
– After this you may need to re-gather table stats on the tables with an invalid index (likely just mailarchive)
Collect stats using "analyze table /your_table_name/ compute statistics;' or DBMS_STATS.gather_tables_stats();