We are using them ...
1. Well AQ tables are in application schema (we have 3 schema that own queues)
2. Schema owner owns the queues and grants subscribe privileges to those who need it.
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
From: Reardon, Bruce (CALBBAY)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 30, 2002 1:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Queues - does anyone use them
Hi,
I've sent a couple of questions on queues and got no answers - that's fine and I understand we're all busy.
What I'm wondering though is whether anyone is actually using Oracle queues at all?
Any feedback would be appreciated.
For anyone out there who does use Advanced queues:
one of our developers read that "Creating a queue table in a tablespace will disable that particular tablespace for point-in-time recovery".
- Do you normally put your AQ tables in a separate tablespace (we're currently looking at doing just that)?
- Who normally owns the queues and queue tables - system or the application schema.
Thanks,
Bruce Reardon
mailto:[EMAIL PROTECTED]
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
