Tables are not shown in Oracle SQL Developer

1

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)
    )
  )
    
asked by anonymous 09.12.2015 / 17:34

1 answer

2

I got a way to access all the tables and the rest of the objects I could not see. The user I'm logging in is associated with the 'x' schema that views a few DB objects but has access to the other objects that by some access limitation is only visible in the 'y' schema. So I just needed to find the schema by doing the following:

  • Right click on the connection;
  • Find DB object;
  • Expand 'All Schemas';
  • Select the schema with access to the visualization of all objects and click Go;
  • This way I can view and edit all DB objects, but unfortunately I have not found a way to show them directly in the connection panel.

        
    14.12.2015 / 17:14