Learn Oracle Plsql
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment