Jul
30
comment Dropping Global Temporary Tables
This is exactly what I was looking for. I generalized your query to look for all locks for GTTs and to do so on RAC. Here is what I am using: SELECT inst_id, sid, username, osuser, machine, terminal, program FROM gv$session WHERE (inst_id, sid) IN (SELECT inst_id, sid FROM gv$lock WHERE type = 'TO');
Jul
30
accepted Dropping Global Temporary Tables
Jul
29
revised Dropping Global Temporary Tables
Shorted SQL
Jul
29
comment Dropping Global Temporary Tables
This is not the behavior we are experiencing. Through trial and error we find the session that is using the temporary table and have the user commit or roll back the session. When they do so the drop succeeds.
Jul
29
asked Dropping Global Temporary Tables
Jul
29
awarded Caucus
Jul
26
awarded Nice Question
Jul
21
awarded Notable Question
Jul
3
awarded Nice Question
Jun
30
awarded Nice Answer
Jun
29
awarded Supporter
Jun
25
comment any way to improve Outlook snooze?
Unfortunately even this method doesn't work in Outlook 2010 because the default snooze option is "5 minutes before start" rather than "5 minutes from now". You can of course tell it "1 minute before start", but you have to make that change ever time the reminder comes up, unless I am missing something.
Jun
15
awarded Yearling
Jun
15
awarded Yearling
Jun
15
revised Pasting text into Excel without splitting on spaces (or other delimiter)
Fixed my name.
May
22
awarded Popular Question
May
21
awarded Popular Question
May
1
awarded Generalist
Apr
15
awarded Nice Answer
Apr
6
comment Is Oracle DB licensing needed for a test environment?
A system that has no production piece is considered a prototype environment and would fall under the OTN License, but as soon as you need to do testing on an environment that is in production, that testing would not be prototyping and would therefore require a license as stated above - at least that is my understanding.
1 2 3 4 5