ORA-04020 deadlock detected while trying to lock object

SQL> create table test (id number);

create table test (id number)

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-04020: deadlock detected while trying to lock object

DICTBAK.BIN$e4PgJIUAyRrgQAEK53B13A==$0

ORA-06512: at line 86

ORA-06512: at line 12

SQL> conn dictbak/1234

Connected.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

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

DDL_ACTION TABLE

TEMPLETE_DICTMODEL01 TABLE

BIN$e4PgJIUAyRrgQAEK53B13A==$0 TABLE

BIN$e4PgJIUWyRrgQAEK53B13A==$0 TABLE

BIN$e4PgJIUayRrgQAEK53B13A==$0 TABLE

BIN$e4PgJIUeyRrgQAEK53B13A==$0 TABLE

BIN$e4PgJIUiyRrgQAEK53B13A==$0 TABLE

7 rows selected.

SQL> PURGE RECYCLEBIN;

PURGE RECYCLEBIN

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 2

ORA-30511: invalid DDL operation in system triggers

ORA-06512: at line 12

SQL> PURGE RECYCLEBIN;

PURGE RECYCLEBIN

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 2

ORA-04020: deadlock detected while trying to lock object

DICTBAK.BIN$e4PgJIUayRrgQAEK53B13A==$0

ORA-06512: at line 86

ORA-06512: at line 12

actions:

关闭系统级DDL触发器

影响的操作类型:

SQL> PURGE RECYCLEBIN;

PURGE RECYCLEBIN

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 2

ORA-04020: deadlock detected while trying to lock object

PERSONALHEALTHRECORD.BIN$fPI0hq5CMArgQAEK53Anjg==$0

ORA-06512: at line 86

ORA-06512: at line 12

drop tablespace

drop user

drop table

datafile

purge recyclebin;