Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    19

    Unanswered: Database Integration between Oracle Bases

    Hi everybody,

    I am an oracle database and now I'm experiencing something new in my job. I have to define the way my company will perform a database integration.
    My situation is this: Here, people are constructing a new, huge system called MEGA with its own Oracle Database. But, there are 20 other smaller systems, each one with their own Oracle Databases that will share data with MEGA Database.
    Here the most commom situation is that some data must be synchronized in x in x hours between the main MEGA database and the other smaller databases. But some data must be synchronized automatically to provide the online data integrity.
    My doubt is: what's the best way to do this integration? Do I have to use Materialized View, Triggers, procedures or is there a tool that comes with Oracle Database that I can use to simplify this data integration?
    Do I have to create a Database to keep the transactional data?
    If someone can give me any hints, I'll be very thankfuled....
    Bye, bye...

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Database Integration between Oracle Bases

    Take a good look at Oracle Replication, which does all this kinf of stuff for you:

    http://download-west.oracle.com/docs...a96567/toc.htm

  3. #3
    Join Date
    Oct 2003
    Posts
    19
    Thank You Tony,

    I will spend my morning in reading the documentation you suggested me.
    But if I get any doubt, may I ask your help later????

Posting Permissions

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