I have some issue in Nested Materialized view. Please have a look and provide the comments.

Source Database Details
===================---

CREATE MATERIALIZED VIEW LOG ON scott.emp_TEST
NOCACHE WITH rowid
INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW LOG ON scott.dept_test
NOCACHE WITH rowid
INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW MV_emp
NOCACHE
ENABLE ROW MOVEMENT
NOLOGGING
NOCOMPRESS
PARALLEL(DEGREE DEFAULT INSTANCES DEFAULT)
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH ROWID
ENABLE QUERY REWRITE
AS
SELECT * FROM emp_TEST@odstoscott;

CREATE MATERIALIZED VIEW MV_dept
NOCACHE
ENABLE ROW MOVEMENT
NOLOGGING
NOCOMPRESS
PARALLEL(DEGREE DEFAULT INSTANCES DEFAULT)
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH ROWID
ENABLE QUERY REWRITE
AS
SELECT * FROM dept_test@odstoscott;

CREATE MATERIALIZED VIEW LOG ON mv_emp
NOCACHE WITH rowid,sequence (EMPNO,ENAME,DEPTNO)
INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW LOG ON mv_dept
NOCACHE WITH rowid,sequence(DEPTNO,DNAME,LOC)
INCLUDING NEW VALUES;

=====want to create nested mviews on the basis of above two Mviews


CREATE MATERIALIZED VIEW MV_prashant
NOCACHE
ENABLE ROW MOVEMENT
NOLOGGING
NOCOMPRESS
PARALLEL(DEGREE DEFAULT INSTANCES DEFAULT)
BUILD IMMEDIATE
REFRESH FAST ON DEMAND
WITH rowid
ENABLE QUERY REWRITE
AS
select E.DEPTNO,D.DEPTNO,e.empno,e.rowid as empid,d.rowid as deptrow
from mv_emp e, mv_dept d
where e.deptno = d.deptno;

While creating mview like above, it's giving below error.

"from mv_emp e, mv_dept d
*
ERROR at line 13:
ORA-12053: this is not a valid nested materialized view "

-- Thanks
Prashant Hirani