Guys,
I had created a materialized view. For example as below.
CREATE MATERIALIZED VIEW schema.mat_repo_view
BUILD IMMEDIATE
REFRESH COMPLETE
ON DEMAND
disable query rewrite
as
select * from table1
I need to alter this view to change my query inside this view. So can I use the alter syntax as below.
ALTER MATERIALIZED VIEW new_employees
AS
select * from table2.
Or do I need to use the same parameters (like refresh clause , build clause etc....) as I used while creating my View. Or I need to specify the sames clauses again while altering the view.(like refresh clause , build clause etc....)
Thanks