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;
/
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle. Issue is currently fixed in the 9.8 Beta release of Toad of Oracle.
Beta releases are available at: http://www.toadsoft.com/beta.html.
