Oracle standard edition replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle standard edition replication

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Oracle standard edition replication

    Hi,

    I need to replicate data from plant to head office and vice-versa.
    Following is our business case.

    exisitng application is running independently at 7 locations Developed using Visual Basic with backend oracle.

    Now we need to maintain data of all locations at all places.

    Can you please help me to handle this using oracle standard edition.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    check out Oracle Streams. It comes with Oracle SE and no additional licenses are not required.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jul 2010
    Posts
    2

    Hi, oracle standard edition streams

    Thanks for your prompt reply.

    Oracle streams is part of Enterprise edition. correct me if I am wrong.

    I am not finding any document on net which says that streams is a part of standard edition.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Look at document ID 567872.1 in Metalink. You need to run Enterprise Edition to get the full advantage of using streams. You can use manual replication, but that requires a lot of work on your part.

    Good luck!
    this space intentionally left blank

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Please look into metalink document id 1084132.1; this document applied to 11.2

    Agree with gandolf, there are some limitations while using streams with SE.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

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



Click Here to Expand Forum to Full Width