Technically, different MViews in a schema would have been built for different purposes (user requirements). So, they are [expected] to be refreshed at different times / intervals. If you need multiple MVs refreshed together, define a Refresh Group.
@Seth.Chatterley3 ай бұрын
How do you define a refresh group?
@albertogonzalez51142 жыл бұрын
Great explanation, thanks so much!
@DatabaseDude2 жыл бұрын
Glad it was helpful!
@ΠροκόπηςΠουλημένος Жыл бұрын
How can we improve materialized views based on complex queries such as join and union and make quicker refresh ?
@DatabaseDude Жыл бұрын
Use DBMS_MVIEW.EXPLAIN_MVIEW to see what is missing in your definition and/or mview log to permit fast refresh
@APOELULTRA79DC5 ай бұрын
Hi this helpful, but for some reason it asks me that I need to declare mview_name. Not sure if its because I am running this code in SQL developer and should run it from the command shell
@DatabaseDude5 ай бұрын
Not sure what you mean. Can you elucidate?
@HemantKChitale2 жыл бұрын
Aah ! How many times do developers and DBAs use / configure an account with the DBA role when the DBA role isn't required !