ORA-37418
detail query cannot be derived
Cause
If an ORANIZATION CUBE MV is to automatically derive its loading clause, then its definition query cannot contain set operators (eg UNION ALL), a HAVING clause, START WITH or a SQL MODEL clause. The definition query contains these or other unsupported syntax.
Action
Use an explicit ORGANIZATION CUBE clause, or simplify the defining query.
ORA-37418
detail query cannot be derived
Cause
If an ORANIZATION CUBE MV is to automatically derive its loading clause, then its definition query cannot contain set operators (eg UNION ALL), a HAVING clause, START WITH or a SQL MODEL clause. The definition query contains these or other unsupported syntax.
Action
Use an explicit ORGANIZATION CUBE clause, or simplify the defining query.
ORA-37418
detail query cannot be derived
Cause
If an ORANIZATION CUBE MV is to automatically derive its loading clause, then its definition query cannot contain set operators (eg UNION ALL), a HAVING clause, START WITH or a SQL MODEL clause. The definition query contains these or other unsupported syntax.
Action
Use an explicit ORGANIZATION CUBE clause, or simplify the defining query.