oracle.jms.AQjmsException: ORA-24067: exceeded maximum number of subscribers for queue FWBZ.SMS_MT_QUEUE
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4459
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQJMS_INTERNAL", line 110
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQJMS", line 101
ORA-06512: at line 1
truncate table aq$_ss_MT_tab_D;
truncate table aq$_ss_MT_tab_g;
truncate table aq$_ss_MT_tab_h;
truncate table aq$_ss_MT_tab_i;
truncate table aq$_ss_MT_tab_p;
truncate table aq$_ss_MT_tab_s;
truncate table aq$_ss_MT_tab_t;
delete from aq$_ss_MT_tab_D;
delete from aq$_ss_MT_tab_g;
delete from aq$_ss_MT_tab_h;
delete from aq$_ss_MT_tab_i;
delete from aq$_ss_MT_tab_p;
delete from aq$_ss_MT_tab_s;
delete from aq$_ss_MT_tab_t;
commit;