This procedure compiles all procedures, functions, packages, views and triggers in the specified schema.
BEGIN
DBMS_UTILITY.COMPILE_SCHEMA(schema => 'XYZ', -- Name of the schema, obviously ;-)
compile_all => FALSE, -- If TRUE, will compile everything within the schema regardless of whether it is VALID
reuse_settings => TRUE); -- Indicates whether the session settings in the objects should be reused, or whether the current session settings should be adopted instead
END;
/
Keine Kommentare:
Kommentar veröffentlichen