I opened TOAD and I'm running a query on a specific table "MI_TABLA" and it only returns 2 records. I ran it in another tool and it returns all the records. In Toad, maybe (for that specific table) I applied some filter and it got stuck or saved persistently. I'm checking "Filter Data.." but there’s no filter.
So far, I'm noticing this happens with 2 tables, with others I don’t have problems.
Could you help me by pointing out where else I should look or check so that the query returns all the records normally?
Toad for Oracle Base Edition (64-bit)
Add-Ons:
26.3.184.10003
Some things I would check:
- I don't see the bottom of the grid where it would show a filter.
- Are you 100% sure that you are connected to the same database and as the same user? A different user could return different rows if a context/vpd/policy is set up.
- Is there any transaction in either connection? you could try COMMIT in both, then re-query.
- try tracing the sessions and look at trace file
My bad John, the tnsnames of both tools point to different databases.
Sorry about that and thanks a lot John!
That's a danger with multiple tnsnames.ora files.
I like to have only one tnsnames.ora on my PC, shared by all Oracle clients, in a folder (like c:\Oracle\TNSADMIN), which is apart from my clients, and specified with TNS_ADMIN environment variable.
Good idea, I'll take it into account.
Thank you very much John!!
