how to start a distributed database

[lucoin]

I have a project to build a distributed database for an organization which run to branches located in Sydney and Melbourne. Sydney office is considered as the head office and Sydney branch office as well. now I have some tables in Sydney head office like CUSTOMER,ORDERS,ORDERLINE,SALESPERSON,PRODUCT, AND SUPPLIER. so how can I fragment to the branches.
PS: I am a beginner to oracle, I am not sure if I ask the right question. In learning...

[debasisdas]

I have a project to build a distributed database for an organization which run to branches located in Sydney and Melbourne. Sydney office is considered as the head office and Sydney branch office as well. now I have some tables in Sydney head office like CUSTOMER,ORDERS,ORDERLINE,SALESPERSON,PRODUCT, AND SUPPLIER. so how can I fragment to the branches.
PS: I am a beginner to oracle, I am not sure if I ask the right question. In learning...

What is the problem if the branches are at different geographical locations . You can still access the same database from any where through LAN or WAN .

[smashzone]

I do not know why you need two databases, you can use one database and access it via LAN using VPN.

Hope this helps
Cheers

Smashzone

[lucoin]

That's why I ask this question. I works yes via the network by access one database in Sydney or whatever. but it will cost network transition much. That's why distributed database, so the local office can trade the certain data locally to improve the efficiency. I just touch distributed database a little, I am not sure my understanding is right. So...?