Demantra Table Reorganization Fails With Database Internal Error - ORA-12008 Error In Materialized View Refresh Path


Demantra reorg fails with Database Internal Error, error in materialized view refresh path

table_reorg.reorg ('DEMANTRA','SALES_DATA','C',30,4) fails & gives the error below. I verified that the tablespaces have Initial Extent of 64K, and I emptied the recycle bin of all objects. I don't find a trace file or any more info in the alert log about this error.

Demantra Collaborator log gives this error info:
Description : Process ID: 801636
Schema ID: 1834
Schema name: 'ReOrg Sales_Data'
Step ID: 'Step1'
Step name: 'SalesDataTableReorg'
Error description 'Database internal error:ORA-12008: error in materialized view refresh path'



Setup issue.
TEMP tablespace did not have enough space for the SALES_DATA table Reorganization to occur.


To implement the solution, please execute the following steps:

1. Increase the size of the TEMP tablespace. For this case it was set to 4 times the size of the SALES_DATA table.

2. Then rerun the Reorganization processes and procedures on the SALES_DATA table.

If you like please follow and comment