Sample Header Ad - 728x90

Created a Materialized View in ORACLE which won't refresh

1 vote
1 answer
1612 views
I created a materialized view log along with a materialized view called update_nboe based on table NBOE_ EMPLOYEES_TEST using the following code
CREATE MATERIALIZED VIEW LOG ON NBOE_EMPLOYEES_TEST WITH primary key;

CREATE MATERIALIZED VIEW update_nboe
REFRESH FAST ON DEMAND
AS
SELECT E.EMP_ID, E.USERNAME ,E.NAME, E.LOCATION , E.TITLE, E.LOCATION_CODE, E.RS_GROUP
FROM NBOE_EMPLOYEES_TEST E;
Then I updated NBOE_EMPLOYEES_TEST by inserting additional records hoping that the materialized view would update and refresh on-demand after using the following piece of code
exec dbms_mview.refresh('update_nboe',atomic_refresh_test=>TRUE);
However, I see a red cross on my connections panel for the materialized view and it won't refresh either. Would appreciate some input.
Asked by HSB (13 rep)
Jan 3, 2020, 12:07 AM
Last activity: Aug 8, 2025, 01:00 PM