oracle compile schema
snippet in sql

oracle compile schema

user7916

-- Compiles all objects of a schema
BEGIN
	-- compile_all: true compiles all, false compiles invalid objects only
	DBMS_UTILITY.compile_schema(schema => 'My_SCHEMA', compile_all => true);
END;