I have had a message stating that ‘IFS database has 4 Invalid Views’
How to i find what these invalid views are?
i am currently using IFS 7.5 SP6
This topic has been closed for comments
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
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?
Userlevel 5
+6
silly question but does this resolve any issue with ‘invalid bodies’ also?
Hi
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.
Userlevel 7
+18
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
Userlevel 6
+18
I have done this but it does not tell me the invalid views it just compiles the objects
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.