Hi,
I have a requirement to refresh a materialised view in Oracle database, read the view and then write to a CSV file.
Reading of the view should only happen after the view is refreshed.
Tried using 2 SQLCreators
First one,
Begin
DBMS_MVIEW.REFRESH(SCHEMA.MVIEW_NAME);
End;
Second One,
Select * from SCHEMA.MVIEW_NAME;
How to make sure that Materialised View will be read only after the view is refreshed?
Thanks
sresree