Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: aq
Simple demo of message propagation
If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications. As long as you’re applications are designed and built to handle it, the “fire and…
dropping tablespaces and queues – not happy companions
grrr… SQL> drop tablespace MY_TSPACE including contents; drop tablespace MY_TSPACE including contents * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: Inappropriate utilities used to perform DDL on AQ table MY_SCHEMA.MY_QUEUE_TABLE You would think that if you ask to…
