|
-
Yes it is very much possible.
You don't need to creat 15 different databases, use Replication. What you can do is create schemas, each one of them representing individual databases and have the database tables in those schemas.
Say you have databases DB1, DB2, DB3...
On DB 1 you have schemas named MNTOWNER, FINOWNER, BOKOWNER etc. Then under those schemas you have tables like MNT_COUNTRIES (for MNTOWNER schema), BOK_PORTS (for BOKOWNER schema).
On the main site you can create a schema named db1owner and have the tables named MNT_COUNTRIES,BOK_PORTS. This way each database tables will be distinguished from each other as they will belong to individual schemas representing those databases. Then you can keep each schema tables in individual replication groups. Say a group named DB1OWNERTABS representing tables from DB1.
Read the replication manual on how to setup replication and create replication groups.
http://otn.oracle.com/docs/products/...a96567/toc.htm
http://otn.oracle.com/docs/products/...a96568/toc.htm
HTH
Amar
"There is a difference between knowing the path and walking the path."

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|