CREATE MATERIALIZED VIEW LOG ON cme.ERP_TK_BACKLOG_DAILY_MV
TABLESPACE TRANSD
WITH ROWID;

CREATE MATERIALIZED VIEW ERP_TKRRL_BACKLOG_DAILY_MV
TABLESPACE TRANSD
NOLOGGING
NOCACHE
NOPARALLEL
BUILD DEFERRED
USING INDEX TABLESPACE TRANSX
REFRESH FAST WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS SELECT * FROM  ERP_TK_BACKLOG_DAILY_MV;

ORA-12053: this is not a valid nested materialized view

ORA-12053: this is not a valid nested materialized view
 *Cause:  The list of objects in the FROM clause of the definition of this
          materialized view had some dependencies upon each other.
 *Action: Refer to the documentation to see which types of nesting are valid.