How can I recompile ALL objects in a pluggable database?
I clone databases from a windows DB (19.11) environment to a linux DB (19.11). In the Windows environment the database is compiled "NATIVE." The Linux DB Ralph's on its shoes when running procedures, etc.
Oracle support has provided a workaround where I set PLSQL_CODE_TYPE=interpreted and run utlrp.sql, twice, unfortunately this does not recompile all of my user defined code.
What I would like is a procedure to recompile everything in the DB (all schemas) which is still compiled "NATIVE."
Does a procedure exist?
If not I was thinking of rolling my own using;
select * from user_stored_settings where param_value = 'NATIVE';