Monday, 21 November 2016

ORA-24005: Inappropriate utilities used to perform DDL on AQ table

We cant directly drop queue tables using drop command .

Follow below steps to drop Queue table:















Syntax:


BEGIN
DBMS_AQADM.DROP_QUEUE_TABLE('name of queue table',TRUE);
END;
/




No comments:

Post a Comment