My Oracle Support Banner

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 NOVEMBER 02, 2018

Applies to:

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


On : version,

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

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

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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