HI MickCOI,

If you have plsql developer try the following.

Log into the database via plsql developer

In the menu tools select Compile invalid objects.

This should show you the invalid views.

Regards,

Sahan

I have done this but it does not tell me the invalid views it just compiles the objects

It doesn’t show you any invalid objects is it? this is a example if you have invalids in the database.

when did you receive the message installing a delivery?

silly question but does this resolve any issue with ‘invalid bodies’ also?

Hi @MickCOl,

If the bodies are invalid, they’ll also appear in the “compile Invalid Object” window. To answer your questions, yes, recompiling will should ideally resolve all invalids, including package bodies.

It’s worth asking (1) why objects are becoming invalid and (2) whether those invalidations are actually causing you trouble.

You might want to check out this other thread:

I want to run invalid packages periodically with DBMS task. | IFS Community

Hi,

This query can be run (as Oracle SYS user) against the DB to get list of invalid objects in the App Owner schema:

SELECT owner, object_type, object_name
FROM all_objects
WHERE status = 'INVALID'
AND owner = '<APPOWNER>';

Compile invalid objects will compile all the objects. The objects may still be invalid if there are any ORA- errors and you can check associated errors by compiling each invalid object from the above list.