Create materialized view syntax

From: Andrew Kerber <>
Date: Wed, 15 Jul 2020 09:27:27 -0500
Message-ID: <>

I am trying to create materialized view, and keep on getting a syntax error with this. Can someone help me fix. I dont use materialized views a lot:

create materialized view myschema.mytable_mv tablespace partition_work
partition by range (create_dt_tm) interval(numtodsinterval(1,'DAY')) subpartion by hash (site_name) subpartitions 64 (
  partition p0001 values less than (to_date('03-NOV-2015','DD-MON-YYYY')) )
refresh fast
as select * from myschema.mytable
ORA-12043: invalid CREATE MATERIALIZED VIEW option

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Wed Jul 15 2020 - 16:27:27 CEST

Original text of this message