Compile all the objects in given schema
You may have the requirement to compile all the invalid objects. in particular schema like ‘APPS’ or ‘SCOTT’ etc. This can be done in may ways. There is option to compile the Invalid objects in APPS schema in Admin utility I have documented about the Adadmin utility in the Unix section. Check out the Unix for the Adadmin utility.
begin
SYS.UTL_RECOMP.RECOMP_PARALLEL(‘N’, ‘Schema_name’);
end;
/
To compile all of the invalid objects owned by APPS
————————————————————-
Note: must use UPPER case on the schema name
begin
dbms_utility.compile_schema(‘APPS’);
end;
/
begin
SYS.UTL_RECOMP.RECOMP_PARALLEL(‘N’, ‘Schema_name’);
end;
/
To compile all of the invalid objects owned by APPS
————————————————————-
Note: must use UPPER case on the schema name
begin
dbms_utility.compile_schema(‘APPS’);
end;
/
Leave a Reply
Want to join the discussion?Feel free to contribute!