108
Logical Change Record Types

This chapter describes the logical change record (LCR) types. In Streams, LCRs are message payloads that contain information about changes to a database. These changes can include changes to the data, which are data manipulation language (DML) changes, and changes to database objects, which are data definition language (DDL) changes.

When you use Streams, the capture process captures changes in the form of LCRs and enqueues them into a queue. These LCRs can be propagated from a queue in one database to a queue in another database. Finally, the apply process can apply LCRs at a destination database. You also have the option of creating, enqueuing, and dequeuing LCRs manually.

LCR types are used with the following Oracle-supplied PL/SQL packages:

• DBMS_APPLY_ADM
• DBMS_AQ
• DBMS_AQADM
• DBMS_CAPTURE_ADM
• DBMS_PROPAGATION_ADM
• DBMS_RULE
• DBMS_RULE_ADM
• DBMS_STREAMS
• DBMS_STREAMS_ADM
• DBMS_TRANSFORM

This chapter contains these topics:

• LCR$_DDL_RECORD Type
• LCR$_ROW_RECORD Type
• Common Subprograms for LCR$_ROW_RECORD and LCR$_DDL_RECORD
• LCR$_ROW_LIST Type
• LCR$_ROW_UNIT Type