Reputation
16,835
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
8 42 117
Newest
 Caucus
Impact
~1.7m people reached

5h
revised Dropping Global Temporary Tables
Shorted SQL
5h
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.
6h
asked Dropping Global Temporary Tables
6h
awarded  Caucus
Jul
21
awarded  Notable Question
Jun
30
awarded  Nice Answer
May
21
awarded  Popular Question
May
16
awarded  Notable Question
May
13
awarded  Popular Question
May
1
awarded  Generalist
Apr
21
awarded  Notable Question
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.
Mar
27
comment Toad Error using Proxy Connection
Not sure what was happening, but the user upgraded toad and the problem went away.
Mar
27
awarded  Nice Answer
Mar
26
asked Toad Error using Proxy Connection
Feb
27
awarded  Popular Question
Feb
23
awarded  Enlightened
Feb
23
awarded  Nice Answer
Feb
2
awarded  Popular Question
Jan
28
awarded  Enlightened