Toad World® Forums

Global Temporary Table visibility after data import

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.