SDDM lacks semantic analysis to support mviews on prebuilts
In SQL*Plus:
create table a as select 1 a from dual;
create table b as select 1 a from dual;
create table c as select 1 a from dual;
create materialized view b on prebuilt table as select a from c;
create materialized view a on prebuilt table as select a from b;
this shall work.
In SDDM the corresponding relational and physical model shall not result in DDL for the mviews in the correct order.
The result is:
ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV
(Part 1 -- I need to go work out, then, I think I still have an Oberon in the fridge)