Where is all_queue_subscribers dictionary view on oracle 9i?
11g and 10g both have the all_queue_subscribers
(and user_
, dba_
) dictionary tables for listing the subscribers to queues, but this doesn't exist on 9i. Does the same concept of queue sub开发者_StackOverflow社区scribers exist on 9i databases, and where can I get this information from?
In 9i the interface was not as friendly. Each queue table had its own view, in the format AQ$<queue_table_name>_S
. This is explained in the documentation. Find out more.
精彩评论