DEMANTRA When Reorganizing sales_data ORA-32422: commit SCN-based materialized view log cannot be created on table.. ORA-06512: at SYS.DBMS_REDEFINITION (Doc ID 1912204.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On :  7.3.1.4 version,

When attempting to exec table_reorg.reorg, the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-32422: commit SCN-based materialized view log cannot be created on table
"<DEMANTRA SCHEMA>"."SALES_DATA" when there exist direct load/PMOP log entries for the table
ORA-06512: at "SYS.DBMS_REDEFINITION", line 56

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. following note Demantra Out of Order Ratio, Table_reorg Procedure, Partitions and Clustering Factor - Manage Your Demantra Database Objects (Doc ID 1548760.1) ,
-- open sql client,  exec table_reorg.reorg
2. Execute exec table_reorg.reorg('<DEMANTRA SCHEMA>','SALES_DATA','C');
3. -- output error obtained

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot finish demantra maintenance, and further execute business operation processes
The project is highly impacted, milestone 14 July

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.