Demantra Table Reorganization Fails With Database Internal Error - ORA-12008 Error In Materialized View Refresh Path
Error:
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'
ERROR
-----------------------
ORA-12008
Reason:
Setup issue.
TEMP tablespace did not have enough space for the SALES_DATA table Reorganization to occur.
Solution
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.
Post a Comment
Post a Comment