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