PL/SQL (MOSC)

MOSC Banner

Materialized views refresh

edited May 31, 2012 9:31PM in PL/SQL (MOSC) 6 commentsAnswered
I have a materialized view with a trigger executing a package inserting events in another table. The refresh on the materialized view is a fast refresh. The materialized view log parameters are primary key and no parallel.

In the most cases the execution is OK but sometimes some lines inserted after others start the package execution before. My question is how the refresh of the lines is ordonnanced in the view? Are there some parameters to set to assure  lines refreshing in insertion or update date order?

Thank you for your Responses.

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