ORA-12015 cannot create a fast refresh materialized view from a complex query while creating a materialized view

Problem 

SQL>CREATE MATERIALIZED VIEW VM_PTL_FRS_COMPLAINTS_MV

  2  on prebuilt table

  3  REFRESH fast

  4  AS

  5  SELECT

  6  PORTAL_COMPLAINT_NO,

  7  COMPLAINT_NO,

  8  SERVICE_TYPE,

  9  REQUEST_STATUS

 10  FROM PTL_FRS_COMPLAINTS@VM;

REQUEST_STATUS

*

ERROR at line 9:

ORA-12015: cannot create a fast refresh materialized view from a complex query

Solution 

   SCHEMA  NAME TO BE USED WHILE CREATING THE MVIEW

 

  1  CREATE MATERIALIZED VIEW VM_PTL_FRS_COMPLAINTS_MV

  2  on prebuilt table

  3  REFRESH fast

  4  AS

  5  SELECT

  6  PORTAL_COMPLAINT_NO,

  7  COMPLAINT_NO,

  8  SERVICE_TYPE,

  9  REQUEST_STATUS

 10* FROM dotsoft.PTL_FRS_COMPLAINTS@VM

 

Snapshot created.