Ramin Hossaini

Recompile invalid objects in an Oracle schema

Apr
14

To compile all procedures, functions, packages, and triggers in a specific schema:

EXEC DBMS_UTILITY.compile_schema(SCHEMA => 'SCHEMA_NAME');

Leave a Reply

Your email address will not be published. Required fields are marked *