Greeting Dear Community.
When we try to change the DDL of a global temporary table. It does not let us even the session is gone long ago.
Is this a bug ??
We are using GTT on a heavy transaction app with very high up time requirement.
So in real prd we would have issue if this happens all the time.
Is there a work around ??
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
"CORE 12.1.0.2.0 Production" 0
TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Error starting at line : 27 in command -
alter table TMP_REPAIR_TRIGGER_ANSWER add (ANSWER_PHRASE varchar2(4000))
Error report -
ORA-14450: attempt to access a transactional temp table already in use
14450. 00000 - "attempt to access a transactional temp table already in use"
*Cause: An attempt was made to access a transactional temporary table that
has been already populated by a concurrent transaction of the same
session.
*Action: do not attempt to access the temporary table until the
concurrent transaction has committed or aborted.
Error starting at line : 27 in command -
alter table TMP_REPAIR_TRIGGER_ANSWER add (ANSWER_PHRASE varchar2(4000))
Error report -
ORA-14450: attempt to access a transactional temp table already in use
14450. 00000 - "attempt to access a transactional temp table already in use"
*Cause: An attempt was made to access a transactional temporary table that
has been already populated by a concurrent transaction of the same
session.
*Action: do not attempt to access the temporary table until the
concurrent transaction has committed or aborted.
Error starting at line : 11 in command -
drop table TMP_REPAIR_TRIGGER_ANSWER
Error report -
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
14452. 00000 - "attempt to create, alter or drop an index on temporary table already in use"
*Cause: An attempt was made to create, alter or drop an index on temporary
table which is already in use.
*Action: All the sessions using the session-specific temporary table have
to truncate table and all the transactions using transaction
specific temporary table have to end their transactions.