TDA is new in our office and it’s been great from querying from a single source, but I’ve had all sorts of performance problems trying to join a list in Excel with a table in our Oracle Banner database. I have boiled the query down to its most basic, joining the Excel identifier to one Oracle table to find its primary key. The query didn’t return any rows in 25 minutes, but I could run it in Access in ten seconds. We want to switch to Toad because it offers broader possibilities. It is actually working, however, because when I pare the data down to 10 rows (from 7000) I do get a result.
I am running W7, Toad 188.8.131.528, and Oracle 11. Having read other posts here I have tried using both the default and Oracle 11g ODBC connections. Both work when I am only pulling from a single source.
I have tried to edit the SQL in my query as well, but whenever I do I this error
ORA-01948: identifier’s name length (48) exceeds maximum(30)
because the table is specified as (this is the default connection version)
So I’m thinking there must be something we’re doing in how we specify our Oracle connection that is causing performance problems. And there must be some way that I can write SQL to select from a table that won’t violate the 30-character table name limit?