Manually refresh materialized view.
Hi All,
I have created a materilized vieww which i need to refresh before my load proess starts. One way is to include refresh clause in Materialized view.
But my requirement is to use shell script. Shell script will execute command to refresh Materilized view. Up on successfully completion, shell script will generate indicator file and based on indicator file, my load process will start.
Can someone help me what is the command to manually refresh materialized view?