How to create a SIMPLE distributed database in Oracle??

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • channa_s
    #1

    How to create a SIMPLE distributed database in Oracle??


    Hi,



    I would be very grateful if anyone could help me with the following. I
    want to create a SIMPLE distributed database. It is as follows:



    There is a institution which has branches all over the country offering
    various courses.

    I want to horizontally fragment the following table and place each
    fragment in each branch.



    COURSE (cno, branch, cname, lecturer)



    I have 2 databases, one in Windows NT and the Other in HP-UX. How do I
    created the GLOBAL schema? How do I create the LOCAL schema?



    Also if I want to replicate the cno and name in each branch for
    improvement of queries, how can I achive this?



    Thanks & Regards,

    Francis


    --
    Posted via http://dbforums.com
    Tags: None
    • Mark D Powell
      #2
      Re: How to create a SIMPLE distributed database in Oracle??

      channa_s <member33438@db forums.comwrote in message news:<3362037.1 063358016@dbfor ums.com>...
      Hi,
      >
      I would be very grateful if anyone could help me with the following. I
      want to create a SIMPLE distributed database. It is as follows:
      >
      There is a institution which has branches all over the country offering
      various courses.
      >
      I want to horizontally fragment the following table and place each
      fragment in each branch.
      >
      COURSE (cno, branch, cname, lecturer)
      >
      I have 2 databases, one in Windows NT and the Other in HP-UX. How do I
      created the GLOBAL schema? How do I create the LOCAL schema?
      >
      Also if I want to replicate the cno and name in each branch for
      improvement of queries, how can I achive this?
      >
      Thanks & Regards,
      Francis
      Francis, in reality there is probably no such thing as a simple
      distributed database since this implies a single logical database
      constructed on a series of physically separate databases that have to
      coordinated for backup, recovery, and usage.

      Distributed processsing on the other hand is fairly simple and
      straight-forward. On the system to be accessed create a user with all
      the desired process privileges. Then on the database that the
      distributed queries will be issued from create a database link that
      connects as the user you just set up on the remote system.

      If only one table is involved in your requirements then using simple
      replication might be a possibility for you.

      Oracle provides several distributed processing manuals as part of the
      documentation set that you should consult.

      IMHO -- Mark D Powell --

        Comment

        Previous template Next
        Working...