Database Administration (MOSC)

MOSC Banner

Materialized View

Dear All:


I have a contingency site with materialized views "on prebuilt table", which worked very well for me with Oracle 11g SEO, then I migrated to 19c SE2 (on both sites) and the processes are running with more delay as time goes by. I don't know what the origin of this will be.


Now I have also realized that materialized views that have LOB type fields cannot be deleted and remain on hold until I manually stop the deletion process. Then I retry delete and the view is no longer found.


Greeting

Marco

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