I have multiple connections configured in TNSNAMES.ORA
, and for some I can not see any tables if they expand the folder.
The user I am connecting to has access because I make queries and insertions normally.
I found a tip on the internet to enable the "Include synonyms" filter option, but it did not work.
I tested with the PL / SQL Developer tool from allroundautomations and in it the tables appear normally, but the tool is trial by 30 days.
As in this second tool the tables appear, I believe it is not some limitation of the user that I use to connect, but I noticed the following difference in TNSNAMES.ORA
: my strings that show the table use SERVICE_NAME
while those that do not show the tabs use SID
.
String example showing the tables:
BDTESTE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serv01)(PORT = 12345))
)
(CONNECT_DATA =
(SID = BDTESTE)
)
)
String example that does not show tables:
BDTESTE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 12346))
)
(CONNECT_DATA =
(SERVICE_NAME = bdteste2.xyz.com.br)
)
)