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 31, 2016

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

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"."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','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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms