# ERROR at line 1: ORA-14452: attempt to create, alter or drop an index on temporary table already in use

**URL:** <https://www.batmunkh.net/t/error-at-line-1-ora-14452-attempt-to-create-alter-or-drop-an-index-on-temporary-table-already-in-use/437>\
**Category:** Tutorials, Solutions\
**Created:** [December 13, 2017, 10:50am UTC](https://www.batmunkh.net/t/error-at-line-1-ora-14452-attempt-to-create-alter-or-drop-an-index-on-temporary-table-already-in-use/437 "2017-12-13T10:50:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [December 13, 2017, 10:50am UTC](https://www.batmunkh.net/t/error-at-line-1-ora-14452-attempt-to-create-alter-or-drop-an-index-on-temporary-table-already-in-use/437/1 "2017-12-13T10:50:51Z")

</div>

Хүснэгт устгах үед энэ алдаа гарвал уг хүснэгтийг хаа нэгтээ ашиглаж байгаа тул устгах боломжгүй гэсэн үг юм. Дараах жишээнд GG schema-гийн GGS\_STICK хүснэгт дээр харуулах болно.

```
SQL> drop user gg cascade;
drop user gg cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use

```

Юуны өмнө ашиглаж байгаа , түгжсэн session id-г олно.

```
select sid from v$lock where id1 = (select object_id from dba_objects where owner = 'GG' and object_name = 'GGS_STICK');

 SID
----------
       151
       281
       344
       408
       155
       184
       257
       440
       361

```

Олон мөр буцааж байгаа тул дараах скрипт ашиглаж бүгдийг хаая.

```
begin
for i in (select sid from v$lock where id1 = (select object_id from dba_objects where owner = 'GG' and object_name = 'GGS_STICK')) loop
  for k in (select sid,serial# from v$session where sid='' || i.SID|| '') loop
  execute immediate 'alter system kill session ''' || k.SID || ',' || k.SERIAL# || ''' immediate';
  end loop;
end loop;
end; 

```

Одоо хүснэгтээ устгая.

```
SQL> drop table gg.ggs_stick;

Table dropped.
```