how to identify materialized view refresh jobs and cancel them?
Hi Everyone,
I am getting this warning during pre-upgrade checks when trying to upgrade a database from 10.2.0.4 to 11.2.0.2:
WARNING: --> There are materialized view refreshes in progress.
.... Ensure all materialized view refreshes are complete prior to upgrade.
I looked in view DBA_JOBS for this_date, this_sec, what and find 9 rows. None of the 'what' look like refresh, and all the other two fields are null. But how to deal with this warning to avoid problems with upgrade?
Thanks.
Yinhai
I am getting this warning during pre-upgrade checks when trying to upgrade a database from 10.2.0.4 to 11.2.0.2:
WARNING: --> There are materialized view refreshes in progress.
.... Ensure all materialized view refreshes are complete prior to upgrade.
I looked in view DBA_JOBS for this_date, this_sec, what and find 9 rows. None of the 'what' look like refresh, and all the other two fields are null. But how to deal with this warning to avoid problems with upgrade?
Thanks.
Yinhai
0