Database Administration (MOSC)

MOSC Banner

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';

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