This content has been marked as final. Show 5 replies
Something in the database is causing them to get marked invalid. You can ask over in the DB general forums this one is focused on sqldev the tool.
The reason I asked the question in this forum is that I believe that it MAY be a bug in SQL Developer.
We simply select STATUS from the dictionary and use that to overlay an icon. What do you see in the dictionary?
Why are Views, Procedures, Triggers being marked as invalid when there has been NO ACTIVITY against the database?
I can correct them today (by recompiling, no changes are necessary); however tomorrow the same Views, Procedures, Triggers will bemarked as invalid.
I can guarantee that there has been NO ACTIVITY in that time frame.
What database? What version?
What version of Sql Developer?
Have you confirmed the object status in the database using a different tool? For Oracle use sql*plus and check the status.
Perhaps you are correct about there being no activity in your database to invalidate those objects. But what about dependencies on remote DB objects that could have been invalidated (perhaps dropped and recreated)?
You may wish to use SQL Developer's object viewer Dependencies tab to check for that possibility. And I wonder about dependency management using timestamps, considering the recent switch to daylight saving time in much of the world.
SQL Developer Team