5/1/2023 0 Comments Refresh option on db solo![]() If you are using the parallel propagation mechanism (that is, parallelism is set to 1 or greater), then: Set this parameter to true if you want the refresh to proceed even if there are outstanding conflicts logged in the DEFERROR view for the materialized view's master table or master materialized view. Used by updatable materialized views only. Otherwise, these changes might appear to be temporarily lost. Set this parameter to true if you want to push changes from the materialized view to its associated master table or master materialized view before refreshing the materialized view. ![]() Specifying NULL without quotes indicates that you do not want to change the rollback segment currently being used. To reset this parameter to use the default rollback segment, specify NULL, including the quotes. By default, the rollback segment remains unchanged. By default, this flag remains unchanged.Īllows you to change the rollback segment used. If this flag is set, then Oracle automatically deletes the group if it no longer contains any members. By default, the interval remains unchanged.Īllows you to reset the value of the implicit_destroy flag. Thus, you should select an interval that is greater than the time it takes to perform a refresh. This interval is evaluated immediately before the refresh. By default, this date remains unchanged.įunction used to calculate the next time to refresh the materialized views in the refresh group. Next date that you want a refresh to occur. Name of the refresh group for which you want to alter the refresh interval. Table 17-3 CHANGE Procedures Parameters Parameter This procedure changes the refresh interval for a refresh group. Otherwise, the call to ADD generates an error message. Oracle then automatically removes the materialized view from the other refresh group and updates its refresh interval to be that of its new group. If you are moving a materialized view from one group to another, then you must set the lax flag to true to succeed. The last position must be NULL.Ī materialized view can belong to only one refresh group at a time. The first materialized view should be in position 1. UNCL_ARRAY, where each element is the name of a materialized view. ![]() Instead of a comma-delimited list, you can supply a PL/SQL index-by table of type DBMS_UTILITY. If the schema is not specified, then the refresh group owner is the default. Synonyms are not supported.Įach materialized view is specified as materialized_view_name. If the schema is not specified, then the current user is the default.Ĭomma-delimited list of materialized views that you want to add to the refresh group. Name of the refresh group to which you want to add members, specified as refresh_group_name. Table 17-2 ADD Procedures Parameters Parameter
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |