DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle 9i Streams for Replication

  1. 10-16-2003, 01:11 PM #1
    Chandra
    Chandra is offline Member
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    Oracle 9i Streams for Replication

    i am planning to implement the A.Replication by using Oracle Stream in 9i. I would like to know did any one has got any suggestions.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin
    Reply With Quote Reply With Quote
  2. 10-17-2003, 05:05 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Oracle 9i Streams for Replication

    Now, Advanced Replication or Streams? Which one?

    Are we taling master-master or master-slave?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 10-17-2003, 08:28 AM #3
    Chandra
    Chandra is offline Member
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    i am planning to do "Streams" master to master.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin
    Reply With Quote Reply With Quote
  4. 10-17-2003, 09:42 AM #4
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by Chandra
    i am planning to do "Streams" master to master.
    Any specific reason for using Streams. When Advanced Replication can take care of this why trying to get you self a headache.

    Streams involes many underlying technologies like logminer, advanced queing, advanced replication, using dblinks etc.

    The concept is to extract changes from redo logs (logminer) and then pass them to a staging area (queuing) then propogate the messages (replication and dblinks) to remote DB then extract the messages on remote DB (queing) and use PL/SQL procedure to apply changes to the required tables.

    The above can be performed in various ways, Streams is a bit complicated and not much help from Oracle themself.

    But then its up to you, want to be adventurous then go ahead. But i would suggest you to stick to Advanced Replication when it can fullfill what you are looking for.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  5. 10-17-2003, 10:09 AM #5
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I would also say that it would be safe enough to use only Advanced Replication.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  6. 10-17-2003, 10:11 AM #6
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by julian
    I would also say that it would be safe enough to use only Advanced Replication.
    I would say this is the first time we have agreed on something so you better listen to us
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width