- There was a Task that I had to schedule refresh MV (Materialized view) cron jobs for every 20min every day, which keeps the Materialized views up-to-date with fresh data from their base tables.
- For this I have created Script files in an Oracle server with Database details like HOST, PORT, DBname, User and DB schema.view and also redirected it to log file.
- I have passed a username and password in a .pgpass file to automate the process.
Leave a Reply