April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed SystemsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Table Replication
Certainly the most versatile and intriguing component of Oracle’s advanced replication facility is multi-master table replication. Any replicated table can be updated anywhere, and the changes will appear in all participating master sites. However, as with any sophisticated technology, you must configure multi-master replication with great care in order to avoid perils and pitfalls.
This section describes the API calls used to create and to maintain replicated tables, points out techniques to make the administration job easier, and describes some practices that will help you to avoid trouble.
API Calls
The fundamental DBMS_REPCAT procedures for administering replicated tables are as follows:
- DBMS_REPCAT. ADD_UNIQUE_RESOLUTION
Adds a uniqueness conflict resolution handler to the table.
- DBMS_REPCAT .ADD_UPDATE_RESOLUTION
Adds an update conflict resolution handler to the table.
- DBMS_REPCAT. DEFINE_COLUMN_GROUP
Creates an empty column group.
- DBMS_REPCAT. DROP_COLUMN_GROUP
Drops a column group.
- DBMS_REPCAT. DROP_UNIQUE_RESOLUTION
Drops a uniqueness conflict handler.
- DBMS_REPCAT. DROP_UPDATE_RESOLUTION
Drops an update conflict handler.
- DBMS_REPCAT. MAKE_COLUMN_GROUP
Creates a column group and assigns columns to the group.
- DBMS_REPCAT. SEND_AND_COMPARE_OLD_VALUES
Specifies which columns should send their previous values to remote sites for comparison during updates and deletes.
- DBMS_REPCAT. SET_COLUMNS
Specifies the column(s) to use to uniquely identify records in the table.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.