Delete and recreate indexes or export/import table
Vorlon1Jun 1 2012 — edited Jun 2 2012I am working on block corruption in several indexes (they are partitioned) and was told to delete and recreate the indexes. The table is not small (2.5b records) and includes a primary key and ~6 other indexes. dbms_metadata.get_ddl is truncating the text of the index, (another issue) so it will be problematic to rebuild the indexes. I have a limited time this weekend to be offline.
IN GENERAL, is it more expedient to rebuild all of the indexes, or simply use the export the table, drop it, and import it approach to recreate the table and indexes?
TIA!