I have often loaded data from Excel to a global temporary table in Toad for Oracle and been able to see/query the data both in Schema Browser and Editor.
With version 12.9.0.71 w/ DB Admin Module, I am now unable to query the data after loading via Schema Browser or when using the EXECUTE button in Editor. When I use Editor and execute my code via the “Run as a Script” button, the data is visible.
The GTT has PRESERVE on commit, hasn’t been modified in years, and I’ve used it as described above flawlessly for years.
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Many thanks!
Michael
Sounds like the import and the Editor are running different sessions. Check to make sure that this option is checked:
Toad Options -> Oracle -> Transactions (RHS) -> Execute Scripts in Toad Session
Also check to make sure “Execute queries in threads” is unchecked.
Thanks! It was “Execute queries in threads”.
Much appreciated!
From: John Dorlon bounce-jdorlon@toadworld.com
Sent: Wednesday, September 7, 2016 12:53 PM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] Global Temporary Table visibility after data import
RE: Global Temporary Table visibility after data import
Reply by John Dorlon
Also check to make sure “Execute queries in threads” is unchecked.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.