|
From: David H. <dav...@jp...> - 2006-08-10 14:37:33
|
It's not a Squirrel problem. Did some checking with other tools. Seems to be a quirk with the way the cluster is configured (or my account). Although the connection string connects me to the proper database/schema (and this is the strange part), it does not make that database/schema the default for queries. So if I do a 'DESC TABLE_A', the query will fail as it doesn't know which database/schema the table belongs. If I do 'DESC ECQSPRD.TABLE_A', it'll work. Doesn't matter that I can't see or have rights any other database/schema other than ECQSPRD. Using 'ALTER SESSION SET current_schema=ECQSPRD' doesn't make a difference to anything but the command line session. Even Oracle's tools (SQLPlus, SQL Developer) have the same problem. They can't see the table, but will allow me to manually query/view them provided I specify which database/schema has the target table. Would there be a setting in Squirrel that would allow me to bypass this quirk (I'd love to be able to browse tables through the GUI)? My DBAs swear the cluster configuration is correct (not a bug, but a feature thing). -- View this message in context: http://www.nabble.com/Oracle%3A-No-tables-shown-tf1902336.html#a5745528 Sent from the squirrel-sql-users forum at Nabble.com. |
