Home » Server Options » Streams & AQ » what are aq (merged) (9.2.0.6)
what are aq (merged) [message #450918] Sat, 10 April 2010 12:49 Go to next message
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 Go to previous messageGo to next message
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: oracle queues [message #450921 is a reply to message #450920] Sat, 10 April 2010 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not multipost your question.
It is useless.
There is a forum for this AQ, stay in it.

Regards
Michel

Re: what are aq (merged) [message #450922 is a reply to message #450918] Sat, 10 April 2010 13:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about reading the documentation at http://tahiti.oracle.com and then tell us what you read and what you don't understand.

Regards
Michel
Re: what are aq (merged) [message #450924 is a reply to message #450922] Sat, 10 April 2010 13:19 Go to previous messageGo to next message
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 #450927 is a reply to message #450924] Sat, 10 April 2010 14:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you think it is a replacement of MV?

Regards
Michel
Re: what are aq (merged) [message #450931 is a reply to message #450927] Sun, 11 April 2010 01:19 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
What is actually doing then ?

I m asked to implement them and replace the MV
Re: what are aq (merged) [message #450934 is a reply to message #450931] Sun, 11 April 2010 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you already read the documentation you should know what is its purpose.

Oracle9i Application Developer's Guide - Advanced Queuing
Chapter 1 Introduction to Oracle Advanced Queuing
Section What Is Advanced Queuing?

Regards
Michel

Re: what are aq (merged) [message #450935 is a reply to message #450934] Sun, 11 April 2010 03:12 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
can u tell me in simple words .
and where it is implemented
Re: what are aq (merged) [message #450937 is a reply to message #450935] Sun, 11 April 2010 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No I can't as I don't know what you know and what is your level.
Explain what you didn't understand from the documentation.

Regards
Michel
Re: what are aq (merged) [message #450938 is a reply to message #450937] Sun, 11 April 2010 03:42 Go to previous message
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.
Previous Topic: unable to create queue table
Next Topic: Replication of data between different schemas at table level
Goto Forum:
  


Current Time: Thu Mar 28 17:53:42 CDT 2024