Database Error Messages

The base tables in the group refreshed successfully but one or more materialized views in the group did not. The status of the group for synchronous refresh operation was set to PARTIAL in this case.

To find the materialized views which failed, query the USER_SR_OBJ_STATUS catalog view. Take one of the following courses of action:

• Issue the EXECUTE_REFRESH command again to retry refreshing the views. In this case EXECUTE_REFRESH will internally use the PCT refresh mode to refresh the materialized views.
• Issue the ABORT_REFRESH command to abort the refresh of all objects in the group, including the base tables, and restore them to the original state.

The base tables in the group refreshed successfully but one or more materialized views in the group did not. The status of the group for synchronous refresh operation was set to PARTIAL in this case.

To find the materialized views which failed, query the USER_SR_OBJ_STATUS catalog view. Take one of the following courses of action:

• Issue the EXECUTE_REFRESH command again to retry refreshing the views. In this case EXECUTE_REFRESH will internally use the PCT refresh mode to refresh the materialized views.
• Issue the ABORT_REFRESH command to abort the refresh of all objects in the group, including the base tables, and restore them to the original state.

The base tables in the group refreshed successfully but one or more materialized views in the group did not. The status of the group for synchronous refresh operation was set to PARTIAL in this case.

To find the materialized views which failed, query the USER_SR_OBJ_STATUS catalog view. Take one of the following courses of action:

• Issue the EXECUTE_REFRESH command again to retry refreshing the views. In this case EXECUTE_REFRESH will internally use the PCT refresh mode to refresh the materialized views.
• Issue the ABORT_REFRESH command to abort the refresh of all objects in the group, including the base tables, and restore them to the original state.