Oracle User-Defined Types

User-defined datatypes (UDDs) use Oracle built-in datatypes and other user-defined datatypes as building blocks that model the structure and behavior of data in applications.

Replication Agent for Oracle supports replication of user-defined object types. Object types are abstractions of real-world entities, such as purchase orders, that application programs deal with. An object type is a schema object with three kinds of components:

A name, which identifies the object type uniquely within that schema.
Attributes, which are built-in types or other user-defined types. Attributes model the structure of the object.
Methods, which are functions or procedures written in PL/SQL and stored in the database, or written in a language such as C or Java and stored externally. Methods implement operations the application can perform on the object.

Creating a Datatype Definition in Replication Server
Create a definition for your user-defined datatype.
Example: Create a Replication Definition
This example demonstrates how to create a replication definition using the rs_char_raw type defined in Replication Server.
Object Type Attribute Replication
To replicate updates to user-defined object type attributes, Replication Agent must enable table-level supplemental logging. Table-level supplemental logging can be enabled manually.

Parent topic: Oracle-Specific Considerations