I have created multiple views that in the script also have connections to database links. In one of the views I receive (a week or so after creating) the error "ORA-04063 View has errors". I do not receive this error if I run the query separately and if I recreate the view it runs without error as well. But again, after a while I receive the above error. I do not have this issue with any of my other views.
Any ideas on what causes this or where I can troubleshoot?