Invalids Created After Incremental and Complete Refreshes (Doc ID 943191.1)

Last updated on FEBRUARY 18, 2024

Applies to:

Symptoms

Invalid Material Views are created after running incremental request set. While recompiling the invalid MVs using the concurrent program "BIS BIA Compile Invalid RSG MVs", the concurrent program errors out with
"ORA-933: SQL command not properly ended".

Steps to reproduce the problem:
1.Check for the invalid MVs registered with RSG present in the environment.
2.Check for the MVs with status "INVALID".
3.Run the concurrent program "BIS BIA Compile Invalid RSG Mvs" in DBI Administrator.
4.Check the log file for the program completed successfully and find the list of Mvs compiled using the program.
5.Check for the status of these MVs in the database.
6.All the Mvs should be in "VALID" state.

Changes

Cause

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