Oracle8 Distributed Database Systems
Release 8.0






Prev Next


This manual describes implemention issues for an Oracle8 distributed database system. It also introduces the tools and utilities available to assist you in implementing and maintaining your distributed system.

Oracle8 Distributed Database Systems contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional.

For information about the differences between Oracle8 and the Oracle8 Enterprise Edition and the features and options that are available to you, see Getting to Know Oracle8 and the Oracle8 Enterprise Edition.

How Oracle8 Distributed Database Systems is Organized

This book consists of two parts:

Part I: Distributed Database Systems

Chapter 1, "Distributed Database Concepts"

This chapter describes the basic concepts and terminology of Oracle's distributed database architecture. It is recommended reading for anyone planning to implement or maintain a distributed database system.

Chapter 2, "Distributed Database Administration"

This chapter discusses issues of concern to the database administrator (DBA) implementing or maintaining distributed databases.

Chapter 3, "Distributed Transactions"

This chapter describes how Oracle maintains the integrity of distributed transactions using the two-phase commit mechanism.

Chapter 4, "Using the Oracle Security Server"

This chapter describes how you use the Oracle Security Server to define global users and global roles in an Oracle server.

Chapter 5, "Distributed Database System Application Development"

This chapter describes the special considerations that are necessary if you are designing an application to run in a distributed system.

Part II: Heterogeneous Distributed Database Systems

Chapter 6, "Understanding Oracle Heterogeneous Services"

This chapter provides an overview of Oracle Heterogeneous Services.

Chapter 7, "Administering Oracle Heterogeneous Services"

This chapter explains how to implement and maintain Heterogeneous Services.

Chapter 8, "Application Development with Heterogeneous Services"

This chapter provides the information you will need to develop applications that use Oracle Heterogeneous Services.

Appendix A, "Heterogeneous Services Initialization Parameters"

This appendix lists all Heterogeneous Services-specific initialization parameters and their values.

Appendix B, "DBMS_HS Package Reference"

This appendix provides all the interface information for the DBMS_HS package. The DBMS_HS package is used to administer the heterogeneous services.

Appendix C, "DBMS_HS_PASSTHROUGH for Pass-Through SQL"

This appendix provides all the interface information for the DBMS_HS_PASSTHROUGH package for pass-through SQL.

Appendix D, "DBMS_DISTRIBUTED_TRUST_ADMIN Package Reference"

This appendix describes the procedures and functions in the package DBMS_DISTRIBUTED_TRUST_ADMIN for administering the Trusted Servers List.

Conventions Used in This Guide

The following conventions are used in code fragments in this guide:


Uppercase text identifies text that must be entered exactly as shown.
For example:

SQLPLUS username/password

lowercase italics


Lowercase italics text is used for emphasis and to indicate glossary terms. It also identifies a variable for which you should substitute an appropriate value. Parentheses should be entered as shown.
For example:

VARCHAR (length)

Vertical bars |


Vertical bars indicate alternate choices. For example:


Braces { }


Required items are enclosed in curly braces, meaning you must choose one of the alternatives. For example:

{column_name | array_def}

Square brackets [ ]


Optional items are enclosed in square brackets. For example:

DECIMAL (digits [ , precision ])



SQL operators are indicated by <operator>. For example:

WHERE x <operator> x

Ellipses ...


Repeated items are indicated by enclosure in square brackets and ellipses. For example:

WHERE column_1 <operator> x 
AND column_2 <operator> y
[AND ...]

Your Comments Are Welcome

We value and appreciate your Comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of this manual is a Reader's Comment Form which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form has been used or you would like to contact us, please contact us at the following address:

Oracle8 Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
Fax: (415) 506-7200


Copyright © 1997 Oracle Corporation.

All Rights Reserved.