How do I resolve issue with materialized view refresh execution

I created 3 materialized views that are not complex and do not have any depencies. I created log tables on all of the views. However, when I execute the refresh command on 2 of the mv I get the following error:

ERROR at line 1:
ORA-12004: REFRESH FAST cannot be used for materialized view
"TEMS_ADM_ORIG"."SINGLE_PAGES_MVIEW"
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 1

There is no errors when I create the mv and their associated log table. I have been trying to refresh the views as the owner of the views.

Here are the materialized views I can't seem to refresh:
 
CREATE MATERIALIZED VIEW MULTI_PAGES_MVIEW 
REFRESH ON DEMAND
AS 
select Decode(SITE,'CBIAC', 'CBRNIAC', 'CPIA', 'CPIAC', site)||'-' ||PDF_NAME as ACCESSION_NUMBER, Decode(SITE,'CBIAC', 'CBRNIAC', 'CPIA', 'CPIAC', site) as site, pdf_name, pdf_page_file_path, DB_INSERTED, DB_UPDATED from multi_pages where site in ('AMMTIAC','CBIAC','CPIA', 'DACS','HSIAC','IATAC', 'RIAC','SENSIAC','SURVIAC','WSTIAC');
 
CREATE INDEX MULTI_PAGES_MVIEW_INDX ON MULTI_PAGES_MVIEW (ACCESSION_NUMBER);
 
CREATE MATERIALIZED VIEW SINGLE_PAGES_MVIEW 
REFRESH ON DEMAND
AS
 select Decode(SITE,'CBIAC', 'CBRNIAC', 'CPIA', 'CPIAC', site)||'-' ||PDF_NAME as ACCESSION_NUMBER, Decode(SITE,'CBIAC', 'CBRNIAC', 'CPIA', 'CPIAC', site) as site, pdf_name, pdf_page_file_path, pdf_page_num from single_pages  where site in ('AMMTIAC','CBIAC','CPIA', 'DACS','HSIAC','IATAC', 'RIAC', 'SENSIAC', 'SURVIAC', 'WSTIAC');

Select allOpen in new window