Schema Browser - Shared DB Llink

Follow / 26 Mar 2018 at 8:25pm

In the schema browser, if I select a DB Link that is "shared", the grid on the right side shows that it is shared.  If I have the right hand view show all of the DB Links the "Shared" attribute is missing from the grid forcing me to select each DB Link one by one to see its properties.

Is there a way to show the "shared" attribute when viewing all of the DB Links?




  • Follow / 26 Mar 2018 at 8:34pm

    Sorry, looks like that info isn't available that way.

    The only thing that comes to mind is that you could click the Filter icon, check "Custom Filter" and "View/Edit Query Before Executing", and then click OK.  A dialog will appear that contains the query that the SB is about to run to load the left hand side.   

    To limit it to shared links, add:   and to_number(bitand(k.flag, 1)) = 1

    To limit it to non-shared links, add:   and to_number(bitand(k.flag, 1)) = 0

  • Follow / 26 Mar 2018 at 9:04pm
    Thanks, that works and will allow me to move forward with what I am doing.  Would this be something that can be enhanced in the future?
  • Follow / 26 Mar 2018 at 9:06pm

    We are no longer adding features for Toad 13 in preparation for release, but I can add it after that (13.1 beta or whatever it will be)

  • Follow / 26 Mar 2018 at 9:15pm
    Sounds great.  Thanks!
  • Follow / 12 Jun 2018 at 11:05pm

    Done for next beta.