This content has been marked as final. Show 3 replies
As a side note I thought I could create one view per DBLink ... then check the status of the view. I have discovered that I can force the creation of the view even when DBLink is invalid, and the view status can now be used to proxy the DBLink status.
Now I am going to try to union/query the set of DBLinks_test views to see if I can get a list of valid DBLinks.
create force view dblink_BAD_LINK_test as select dummy from dual@BAD_LINK.world;
Found the list of INVALID status' in user_objects.
Create fore view using dblink, use user_object sys table to check valid/invalid flag.