I am using Toad for Oracle Base (Version 10.6.0.42). Is it possible to do a cross connection query in this software? I am having the most difficult time trying to figure it out. Other forums list selected the ‘cross connection query’ option in the query builder, but this does not appear in my version. Instead, the query builder only has an option to select the connection.
I was able to build a query in the query builder with tables from both connections, but when I run it an error pops up about the second table not existing. If I switch connections, then the error goes to the first table not existing. Thus, I do not think Toad is recognizing the cross connection query correctly.
Is there an option to enable this? If not, is there some valid syntax for me to reference the connections? I am not sure where a navigation manager is in my version either, since the version is somewhat older.
Please help if you can!