By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,978 Members | 1,362 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,978 IT Pros & Developers. It's quick & easy.

How to create a SIMPLE distributed database in Oracle??

P: n/a

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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
channa_s <me*********@dbforums.com> wrote in message news:<33****************@dbforums.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 --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.