I have a schema where only a single DB_Link exists (SCHEMA1) on the entire schema. On another schema with DBA rights, I open the Schema Browser and go into a Treeview mode. By default I see the SCHEMA1 schema in the "Other Schemas" section. However I then right-click the Other Schema branch and select -> Users to Load | Load Only Users that Own Objects. Then the SCHEMA1 schema disappears. So Toad hides schemas where only a DB_Link exists. (No tables, procs, etc.).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center