Create materialized view syntax

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 15 Jul 2020 09:27:27 -0500
Message-ID: <CAJvnOJZiM+7o8ytGTR+Jex00AAZTsdWzyboo8=mBXXMyYYP9zg_at_mail.gmail.com>

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')) )
parallel
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.'

--
http://www.freelists.org/webpage/oracle-l

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