Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-16553

Performing the mailarchive long->clob conversion results in invalid/unusable indexes (ORA-01502)

    Details

      Description

      This will mostly be a release documentation issue related to the fix for SAK-16463 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();

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  arwhyte Anthony Whyte
                  Reporter:
                  jonespm Matthew Jones
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration