cannot drop queue
SQL> BEGIN
2 SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
3 (
4 QUEUE_TABLE => 'SOA_EGDI.SOA_EGDI_QT'
5 ,QUEUE_PAYLOAD_TYPE => 'SOA_EGDI.GDI_E_PAYLOAD'
6 ,COMPATIBLE => '8.1'
7 ,STORAGE_CLAUSE => '
8 TABLESPACE EGDI_L_D
9 PCTUSED 0
10 PCTFREE 10
11 INITRANS 1
12 MAXTRANS 255
13 STORAGE (
14 INITIAL 80K
15 MINEXTENTS 1
16 MAXEXTENTS UNLIMITED
17 PCTINCREASE 0
18 BUFFER_POOL DEFAULT
19 )'
20 ,SORT_LIST => 'ENQ_TIME'
21 ,MULTIPLE_CONSUMERS => FALSE
22 ,MESSAGE_GROUPING => 0
23 ,SECURE => FALSE
24 );
25 End;
26 /
BEGIN
SYS.DBMS_AQADM.BEGIN
*
ERROR at line 1:
ORA-24001: cannot create QUEUE_TABLE, SOA_EGDI.SOA_EGDI_QT already exists
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2830
ORA-06512: at "SYS.DBMS_AQADM", line 58
ORA-06512: at line 2
SQL> 2 CREATE_QUEUE
3 (
4 QUEUE_NAME => 'SOA_EGDI.GDI_QUEUE'
2