DB versions: 12.1, 19c
I have around 30 invalid objects across mutliple schemas. I fixed the root cause of why they were INVALID. It was because of various reasons like missing grants, missing public synonyms, etc.
Now, I want to recompile all of them. i.e. recompile all invalid objects across all schemas in the DB. Instead of doing one by one at schema level like below, is there a quick way to do it in all schemas in one go ?
EXEC UTL_RECOMP.recomp_parallel(2, 'SCOTT');