Compilando objetos invalidos usando DBMS_UTILITY

DBMS_UTILITY.compile_schema

The COMPILE_SCHEMA procedure in the DBMS_UTILITY package compiles all procedures, functions, packages, and triggers in the specified schema.
The example below shows how it is called from SQL*Plus:

SQL> exec dbms_utility.compile_schema(schema => 'SCHEMA');

Comentários