We have a daily process which is executed by our users.
Every evening after the stock market closes one of our users loads the stock_price table with todays stock_price data.
Basically he/she just has to hit a submit button which executes a stored procedure and the data is loaded from a various sources into the tables.
Now I want to execute another process say a refresh of a Materialized view from within this procedure but dont want the user to wait till the time its over.
As far as the user is concerned his job is done. He doesnt want to wait for the refresh of MV to be done.
Is there a way where I can fork out another process or something to refresh the MV and still proceed with the execution of the current stored procedure.
I hope i was clear enough.
You can if you think you can.