My Oracle Support Banner

How To Disable A Materialized View Refresh Over A Database Link (Doc ID 2923571.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
How to disable a materialized view refresh over a database link

 

The remote site (where the source tables are) is database "A" and the materialized views are on database "B".

The materialized views are created and refreshed over a database link. The two databases have different set of DBAs and the DBAs only have access to one database only.

Database "A" DBAs do not have access to the MView site database.

The mviews are scheduled to refresh automatically at midnight.

How do you prevent users on Mview site from running mview refreshes during the day? .

Locking and or Revoking create session on the account used to refresh the mview, does not prevent the refresh from working.

 



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.