From SQL Developer I need to connect to an Oracle database where, however, the username is of the form name.sirname[schemaname]
By using other sw, as PL/SQL Developer or TOAD, I've got no problem, whereas by using SQL Developer I can't
The tnsnames contains:
Example =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dn-hostname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ExampleSN)
)
)
and this is the error. Could it be the presence of [schemaname]?
Bacause if I put only name.sirname I can connect but I don't see anything (tables, …)
