Database Administration (MOSC)

MOSC Banner

Question related to TRIGGER on read only Materialized views

edited Jan 29, 2010 3:10PM in Database Administration (MOSC) 2 commentsAnswered

  We have a Read Only Materialized view created on a pre-built table. The Materialized view is refreshed via FAST refresh option.

 

We have a row level trigger defined on the above pre-built table. However, this trigger DOES NOT alter the content of the Materialized View base table (Pre-built) itself.

 

The trigger populates/maintains another TABLE in the schema as the Read ONLY Materialized view. We have been having this set up and is running on Oracle 9i and Oracle 10g as well. We are in the process of upgrading the database to 11g. Hence we would like to check if you foresee any issues continuing with the above set up.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center