Skip to content
Advertisement

Oracle SQL Developer flag my working views as broken

Can anyone share me some light on why my Oracle SQL Developer flagged my view as broken while it is actually working?

enter image description here

enter image description here

enter image description here

It is not just 1 view, but 10 views have the same problem, they are all created in a different time, with subquery or joining to multiple tables and is always working fine.

Thanks in advance!

Advertisement

Answer

Probably the view was invalidated by a change to a referenced object. Like stored PL/SQL, a recompilation will occur when it is next used, when it will become valid again. For example:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement