fereally.blogg.se

catch( function(err) Unhandled Promise rejection: EXCEPTION: Error in. " angular2-materialize": " node_modules/angular2-materialize" " materialize": " node_modules/angular2-materialize", " materialize-css": " node-modules/materialize-css", Oh, and my test environment was Oracle 10.2.0.3, on your (9i) results may vary.Copy Code Angular 2 QuickStart ORA-12015: cannot create a fast refresh materialized view from a complex querySo, it looks like ANSI Joins are counted as complex queries and since i don't see any restriction in this regard in the documentation, i assume it to be a bug.

Materialized view created.Now, if you put the ON COMMIT attribute away, you get something more understandable error message. ORA-12003: materialized view "SCOTT"."EMP_MV" does not exist

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view SQL> CREATE MATERIALIZED VIEW emp_mv build immediateĤ SELECT e.rowid e_rowid,d.Rowid d_rowid, d.deptno,d.dname,e.enameĥ FROM dept d JOIN emp e ON (d.deptno=e.deptno) įROM dept d JOIN emp e ON (d.deptno=e.deptno) SQL> CREATE MATERIALIZED VIEW LOG ON dept WITH ROWID,SEQUENCE(deptno) SQL> CREATE MATERIALIZED VIEW LOG ON emp WITH ROWID,SEQUENCE(deptno)