Skip to Main Content
Oracle Built-in Packages
book

Oracle Built-in Packages

by Steven Feuerstein, Charles Dye, John Beresniewicz
May 1998
Intermediate to advanced content levelIntermediate to advanced
956 pages
30h 12m
English
O'Reilly Media, Inc.
Content preview from Oracle Built-in Packages

Part IV. Distributed Database Packages

This part of the book describes the built-in distributed database packages:

  • Chapter 14, explores the packages, DBMS_SNAPSHOT, DBMS_REFRESH, and DBMS_OFFLINE_SNAPSHOT, and some programs in DBMS_REPCAT that show how to maintain snapshots, snapshot groups, and snapshot logs.

  • Chapter 15, explains how to use DBMS_REPCAT, DBMS_REPUTIL, DBMS_OFFLINE_OG, DBMS_REPCAT_ADMIN, DBMS_REPCAT_AUTH, and DBMS_RECTIFIER_DIFF to create and to administer your replicated databases.

  • Chapter 16, shows you how to configure Oracle to automatically detect, correct, and report many forseeable conflicts by using procedures in DBMS_REPCAT to create and maintain custom resolution methods.

  • Chapter 17, introduces the DBMS_DEFER package and shows you how to queue deferred remote procedure calls (RPCs) and use DBMS_DEFER_QUERY and DBMS_DEFER_SYS to perform administrative and diagnostic activities.

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.
Start your free trial

You might also like

Oracle Databases

Oracle Databases

O'Reilly Media, Inc.
Learning Oracle PL/SQL

Learning Oracle PL/SQL

Bill Pribyl, Steven Feuerstein

Publisher Resources

ISBN: 1565923758Supplemental ContentCatalog PageErrata