PLS-00201: identifier 'DBMS_AQADM' must be declared

While trying to drop QUEUE table, the subjectlined issue may arrise.

The error a bit confusing. It's nothing but a permission issue.

Select OWNER, IOT_NAME, IOT_TYPE from dba_tables

OWNER    TABLE_NAME                 IOT_NAME                    IOT_TYPE

SCOTT    SYS_IOT_OVER_74142    AQ$_QUEUE_TABLE    IOT_OVERFLOW

Grant  EXECUTE ON DBMS_AQADM to SCOTT

exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'AQ$_QUEUE_TABLE',force => TRUE);