CREATE OR REPLACE MATERIALIZED VIEW
Hi,
I am getting the error mentioned below with REPLACE option in create statement for Materialized views. Could you please let me know whether REPLACE option works for materialized views.
CREATE OR REPLACE MATERIALIZED VIEW test_mv
REFRESH ON DEMAND AS
select * from emp
Error:
create or replace materialized view test_mv
*
ERROR at line 1:
ORA-00922: missing or invalid option
I tried in Oracle 9i and Oracle 8i
Thanks
Sowjanya