Distributed database system

[janjacina]

I have a cluster. 5 computers. 1 root and 4 nodes. I would like create distributed DB. On each of computer is one istance of Oracle 9 Rel. 2. I allready defined DB links on root computer.
How can I create table with horizontal fragmentation ?
Ex.
Comp root Comp1 Comp2 Comp3 Comp4
ID < 1000 ID < 2000 ID < 3000 ID < 4000 ID < maxvalue

Is it possible with table partitioning (more tablespaces...) or ?

Could you write me some steps ?

Thank you

[pando]

I am not sure, but are you talking about replication or you want to partition your data?

The way you are describing looks more like a SQL Server cluster where you have to partition your data (I am not sure if this is still true in SQL Server 2000) in different nodes. Oracle Real Application Clusters doesnt work that way, everything is shared and not partitioned horizontally. All nodes access same data in the shared disks.

Replication is different story, your ID s stored in all nodes. Duplicated or replicated whatever you want to call them.

Replication is distributed! I dont think clustered can be called distributed.

[janjacina]

hmmm

I think you right... cluster != distributed

I want to create more partitions for one table, not replication.
I have 5 instances of Oracle and i would like create 5 partitions for one table. Each partition on different computer.


DBS - Oracle 9.0.2

[pando]

well Oracle doesnt work that way, you need shared disks i.e a proper array disk

[janjacina]

How can I create distributed database system (Oracle). I have 5 computers. I have to define fragments for database.



Thank you for all your ideas

[pando]

you need t read the manals in tahiti.oracle.com, read Real Application Clusters Concept guide

hard to digest!

I read 50 pages and fall asleep zZzZzZzZzzz

[adewri]

Originally posted by pando
you need t read the manals in tahiti.oracle.com, read Real Application Clusters Concept guide

hard to digest!

I read 50 pages and fall asleep zZzZzZzZzzz

So thats the reason for sleeping well Read the first 50 pages every day before going to bed