Techniques for replicating a database object of a relational database
managed by a database system from a first node on a network to a second node on
the network include determining that the database object on the first node includes
a user-defined object. A first routine of the database system is invoked. The first
routine performs the step of copying the database object to the second node of
the network. The first routine copies a name of a user-defined defined type of
the user-defined object from the first node to the second node. The first routine
also copies a first definition of the user-defined type from the first node to
the second node. The first routine then copies a second definition of the database
object from the first node to the second node. The second definition includes the
name of the user-defined type. These techniques provide the benefits of peer-to-peer
replication in a distributed database to users of object-relational databases that
including user-defined objects.
