ORA-14450: attempt to access a transactional temp table already in use

create global temporary table tt
(id number,
cc varchar2(8)
)

on commit delete rows;

//进行commit时删除表中的数据;

create global temporary table tt2
(id number,
cc varchar2(8)
)

on commit preserve rows;

//进行会话退出或中断时删除数据;

未将里面数据清空时将报以上错误:ORA-14450;

-------------------------

解决办法:

ORA-14450: attempt to access a transactional temp table already in use

第一:

select * from v$lock where id1=(

select object_id from dba_objects where owner='AIKI' and object_name='AIKI_TEMP')

第二:

根据得出的结果SID

直接kill 会话；

再次执行alter 成功!