Create Script or Export DDL does not generate the correct Drop statement on Queue tables. The Drop parameter ends with an ":" colon instead of a ";" semicolon. This statement cannot be executed as it is not syntactically correct:
BEGIN
SYS.DBMS_AQADM.DROP_QUEUE_TABLE
(QUEUE_TABLE => 'DEMO_QUEUE_TABLE'):
END;
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center