For tables with materialized view log, is it necessary to recreate the materialized view log after the reorganization?
Yes, in the following conditions, it is required for the materialized view logs to be recreated after reorganization of tables with materialized view logs:
1. Tables contain LOBs
2. Materialized view logs use WITH ROWID
Reorg Manager performs check against the above conditions for the tables that are selected to reorganize. If the conditions are met, Reorg Manager provides a message to warn that the materialized view log will have to be manually recreated if the table is reorganized. At this stage, the user is given a choice to remove the table from the reorganization.
