Mittwoch, 14. Juni 2023

Compile invalid object of the schema

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