A change set is a logical grouping of change data that is guaranteed to be transactionally consistent and that can be managed as a unit. A change set is a member of one (and only one) change source. A change source can contain one or more change sets. There are three modes of change sets, as follow:
- Synchronous
- Asynchronous HotLog
- Asynchronous AutoLog
Publishers can purge unneeded change data from change tables at the change set level to keep the change tables in the change set from growing larger indefinitely.
Change Tables:
A given change table contains the change data resulting from DML operations performed on a given source table. A change table consists of two things: the change data itself, which is stored in a database table, ; and the system metadata necessary to maintain the change table, which includes control columns.
No comments:
Post a Comment