I create a tsm file that I like to share with my colleagues but when they load my tsm file and tries to run the query, it thorws the error:
"ORA-00942: table or view does not exist."
Earlier Toad for Data Analyst versions like version 1.1 creates queries with the current schema as a qualifier. For example, if you are logged in with schema A and you created a query from schema B, instead of getting
B.Table
the Query Builder shows
A.Table
Hence when others try to run your query, it is running a query with a schema qualifier that does not own the table.
Later Toad for Data Analyst version (v2.6 and up) do not have this issue. You should be able to share tsm files with later Toad versions. You can download the lastest version of TDA from https://support.quest.com.
