- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Table replication over different ORACLE instan...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 02:53 AM
тАО03-19-2007 02:53 AM
I've a question about distributed databases synchronization over geographic networks.
We've an ORACLE instance rdbms_A in a platform host_A where an application app_A is running.
We've an ORACLE instance rdbms_B in a platform host_B where an application app_V is running.
rdbms_A and rdbms_B have different schemas.
rdbms_A has a table "paths" composed by a set of attributes; a view "paths_4BM" is built on top of "paths": this view contains a subset of "paths" attributes.
rdbms_B has a table "paths_RM" identical to "paths_4BM".
The data insert sequence is the following:
> the data are inserted, modified or deleted only in rdbms_A; only "paths" is modified (and the view changes accordingly).
> the data in rdbms_B should be kept aligned.
We need to keep aligned "paths_RM" to "paths_4BM" in an automatic way.
Are there any ORACLE embedded mechanisms to automatically updated tables on RDBMS B when the (linked) data on RDBMS A change?
We need a "per table" relation.
Thanks
Enrico
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 03:24 AM
тАО03-19-2007 03:24 AM
Re: Table replication over different ORACLE instances
Try it with database link and triggers?
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 03:30 AM
тАО03-19-2007 03:30 AM
Re: Table replication over different ORACLE instances
what should I do?!?
Please go into details.
regards
Enrico
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 03:43 AM
тАО03-19-2007 03:43 AM
Re: Table replication over different ORACLE instances
Synchron:
now create a trigger (on insert or/and on update event) on table "paths" which writes the data directly through the database link in the table of the rdbms_B database.
Asynchron:
Or you can write a job in rdbms_B, that for e.g. all two minutes reads the new data in table paths of rdbms_A.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 04:07 AM
тАО03-19-2007 04:07 AM
Re: Table replication over different ORACLE instances
How can I do it?
Are there any specific ORACLE commands?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2007 04:15 AM
тАО03-19-2007 04:15 AM
Re: Table replication over different ORACLE instances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2007 03:31 AM
тАО03-20-2007 03:31 AM
Re: Table replication over different ORACLE instances
If you are on 10g, read Metalink Note 394575.1 about streams replication.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2007 10:03 PM
тАО03-21-2007 10:03 PM
Solutionone way to achieve this is to create a synonym using a database link as follows:
CREATE OR REPLACE PUBLIC SYNONYM paths_4bm FOR
hope this helps!
kind regards
yogeeraj