'Unable to refresh Materialized view manually in Oracle12c
I created a materialized view as show below:
CREATE MATERIALIZED VIEW ORA2ORA_DW.INVOICE_AGG
BUILD IMMEDIATE
REFRESH FORCE
ON DEMAND
DISABLE QUERY REWRITE
AS
SELECT C.CUSTOMERID , C.CUSTOMERNAME, SUM(I.QUANTITY) AS QUANTITY, MAX(I.UNITPRICE) AS UNITPRICE, MIN(I.TAXAMOUNT) AS AMOUNT,
AVG(I.TAXRATE) AS TAX, VARIANCE(I.LINEPROFIT)AS LINEPROFIT_VAR, STDDEV(I.LINEPROFIT) AS LINEPROFIT_STDEV, COUNT(I.INVOICELINESKEY) AS ROW_COUNT
FROM ORA2ORA_DW.INVOICELINES I, ORA2ORA_DW.CUSTOMERS C
WHERE I.CUSTOMERSKEY=C.CUSTOMERSKEY
GROUP BY C.CUSTOMERID , C.CUSTOMERNAME
ORDER BY C.CUSTOMERID;
but when I try to refresh it using this command "EXEC DBMS_MVIEW.REFRESH('INVOICE_AGG');", it gives me this error: ORA-00900: invalid SQL statement
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
