title: Cannot drop Oracle queue table with DBMS_AQADM.DROP_QUEUE_TABLE
body: <p>I'm trying to clean up an accidental installation of LOG4PLSQL into the wrong (i.e., SYS) schema. There is a queue table called <code>QTAB_LOG</code> that needs to go away. I have successfully stopped and dropped the associated queue:</p>
  
  <pre><code>call DBMS_AQADM.STOP_QUEUE('LOG_QUEUE');
  call DBMS_AQADM.DROP_QUEUE('LOG_QUEUE');
  </code></pre>
  
  <p>But dropping the queue table itself fails:</p>
  
  <pre><code>call DBMS_AQADM.DROP_QUEUE_TABLE('QTAB_LOG');
  </code></pre>
  
  <p>with this error:</p>
  
  <pre><code>SQL Error: ORA-00942: table or view does not exist
  ORA-06512: at "SYS.DBMS_AQADM", line 240
  ORA-06512: at line 1
  00942. 00000 -  "table or view does not exist"
  </code></pre>
  
  <p>And of course dropping the table the normal way:</p>
  
  <pre><code>drop table QTAB_LOG;
  </code></pre>
  
  <p>is not allowed:</p>
  
  <pre><code>SQL Error: ORA-24005: Inappropriate utilities used to perform DDL on AQ table LOG4PLSQL.QTAB_LOG
  24005. 00000 -  "must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables" 
  *Cause:    An attempt was made to use the SQL command DROP TABLE for queue
             tables, but DROP TABLE is not supported for queue tables.
  *Action:   Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure instead of the
             DROP TABLE command.
  </code></pre>
  
  <p>What am I doing wrong?</p>