ORA-14452 при попытке DDL на временной таблице

SQL> drop table SOME_GTT_TABLE;

drop table SOME_GTT_TABLE
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

SQL> with locked_obj as
2   (select o.object_id
3      from dba_objects o
4     where o.owner = sys_context('userenv','CURRENT_SCHEMA')
5       AND o.object_name = 'SOME_GTT_TABLE')
6  select i.host_name,
7         case
8           when s.inst_id = sys_context('userenv', 'instance') and
9                s.sid = sys_context('userenv', 'sid')
10           then 'My own session'
11           else 'Alter system kill session ''' || s.SID || ',' || s.SERIAL# ||
12            ''';'
13         end as KILL_SESSION,
14         l.type
15    from gv$lock l, locked_obj, gv$session s, gv$instance i
16   WHERE l.id1 = locked_obj.object_id
17     AND s.sid = l.sid
18     AND s.inst_id = l.inst_id
19     AND s.inst_id = i.inst_id
20  /

HOST_NAME       KILL_SESSION                           TYPE
--------------- -------------------------------------- ----
host1f.prod.ru  My own session                         TO
host1f.prod.ru  Alter system kill session '453,1309';  TO
host2f.prod.ru  Alter system kill session '458,2337';  TO

SQL> select * from v$lock_type where type = 'TO';

TYPE  NAME         ID1_TAG   ID2_TAG  IS_USER DESCRIPTION
----- ------------ --------- -------- ------- ----------------------------------------------------
TO    Temp Object  object #  1        NO      Synchronizes DDL and DML operations on a temp object

About these ads