ORA-00933: SQL when I try to refresh a Materialized View

237 Views Asked by At

When I try and run the following refresh for a MATERIALIZED VIEW

ALTER materialized VIEW table_name.materialized_view_name refresh FORCE START 
WITH trunc(SYSDATE, 'HH24') + 2/24 NEXT SYSDATE + 6/24; 

I'm getting ORA-00933: SQL command not properly ended, however I am unable to see how it is not properly ended

0

There are 0 best solutions below