This Appendix briefly describes the new replication features of the Oracle8 Server and provides pointers to other chapters in this document where you can get additional information.
New features include:
Oracle8 provides significant performance improvements based on the following new features.
Dramatically improves throughput performance by parallelizing the propagation of a replication transaction stream while maintaining consistency and transaction dependencies.
Additional Information: See "Deciding between Serial and Parallel Propagation" on page 3-11.
Additional Information: See "Oracle's Advanced Replication Architecture" on page 1-20.
Oracle8 reduces the amount of replicated data propagated over the network. Propagation can be reduced to only the following: new values of columns updated; old values of columns needed for conflict detection and resolution; and primary key values. This feature is important for performance when replicating LOBs.
Additional Information: See "Minimizing Data Propagation for Update Conflict Resolution" on page 5-40.
Snapshots defined with certain types of subqueries can now be fast refreshed. This enables subsets of data to be easily defined and maintained. This feature is important for mass deployment applications, such as salesforce automation and branch automation.
Additional Information: See "Creating Snapshots with Subqueries" on page 2-16.
Oracle8 supports the replication of the following types of large objects:
Additional Information: See the following sections: "Datatype Considerations for Replicated Tables" on page 3-20, "Datatype Considerations for Snapshots" on page 4-18.
Oracle8 facilitates database management with the following features.
Replication master groups can now be individually quiesced without impacting other replication groups. Master groups can continue to replication updates while other master groups are quiesced.
Additional Information: See "Suspending Replication Activity for a Master Group" on page 3-17.
Primary key snapshots allow you to reorganize master tables while preserving fast refresh capability. Oracle8 adds primary key snapshots as the default, and continues to support ROWID snapshots.
Oracle8 automatically registers information about a snapshot s at master sites. This facilitates monitoring and distributed administration.
Additional Information: See "Registering a Snapshot at its Master Site" on page 2-35.
Oracle8 provides utilities to enable you to "reorg" master tables while preserving the consistency of master snapshot logs.
Additional Information: See "Master Table Reorganization and ROWID Snapshots" on page 2-43.
Offline instantiation of schemas and database using Export/Import is now more automatic.
Additional Information: See "Snapshot Cloning and Offline Instantiation" on page 7-14.
Updatable snapshots now support declarative referential and uniqueness constraints.
Additional Information: See "Replicating Object Definitions to Master Sites" on page 3-21.
A new procedure validates the correctness of multiple master environments to help avoid errors.
Additional Information: See "Validating a Master Group" on page 6-2.
Oracle8 supports the replication of partitioned tables and indexes. You can use this feature if you want the replicated table to have the same partitions as the table at the master definition site.
Oracle8 system-based security model:
Additional Information: See "Preparing for Multimaster Replication" on page 3-4, "Preparing for Snapshot Site Replication" on page 4-5, and Appendix B, "Migration and Compatibility".
Replication Manager now includes several wizards to help you configure your system quickly.
Oracle Replication Manager includes support for most new features of Oracle8 Server replication functionality, including: