what are aq (merged) [message #450918] |
Sat, 10 April 2010 12:49 |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
what are advanced queues . I have read many definations and the procedure to create them
But how can i use them to replace materialized view. As i have to implement this on the database to replace all the materialzed views . Please help me explain.
|
|
|
oracle queues [message #450920 is a reply to message #450918] |
Sat, 10 April 2010 12:51 |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
what are advanced queues . I have read many definations and the procedure to create them
But how can i use them to replace materialized view. As i have to implement this on the database to replace all the materialzed views . Please help me explain.
|
|
|
|
|
Re: what are aq (merged) [message #450924 is a reply to message #450922] |
Sat, 10 April 2010 13:19 |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
I have read most of the document about publishers and subscribers and how queues are implementing by creating queues and queue tables ....
But very confused and not getting conviced of why and where it is implemented and how it can be a replacement for MV.
kindly help
|
|
|
|
|
|
|
|
Re: what are aq (merged) [message #450938 is a reply to message #450937] |
Sun, 11 April 2010 03:42 |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
what i understood is that
1. Create a message type - which can be record of table
2, Create a queue table , queue , start the queue
then how we are pushing messages or (type) in the queues and transferring it . IS a method of replication and if yes how it is better than other methods.
|
|
|