This content has been marked as final. Show 4 replies
No, you can invoke dbms_mview.refresh to refresh a single view.
If you are getting an error, it may be caused by the refresh method that you specified (or not specified).
Snowman wrote:What error are you getting?
I have created a materialized view, and am attempting to create a process in APEX to refresh the mview on a button click.
I have been reading the documentation on Materialized Views and think I am more confused now than when I started.
Do I need to add my mview to a refresh group to enable me to use the DBMS_REFRESH.REFRESH command from an APEX process?
The current error I'm getting is - ORA-23404: refresh group "WORKSPACE"."REG_MON_BSA" does not exist
Here is my code.
I had found another post re materialized views and was following the steps there, but they didn't work...
declare my_schema varchar(100); BEGIN select owner into my_schema from apex_applications where application_id=:APP_ID; dbms_refresh.refresh(my_schema||'.'||'REG_MON_BSA'); END;
you are using the wrong package, don't use DBMS_REFRESH.REFRESH, use DBMS_MVIEW.REFRESH.