Compile all the invalid objects in a Schema

begin
dbms_utility.compile_schema('SCHEMA');
end;
/

Note: Schema name should be in UPPER Case

No comments:

Post a Comment