Table-Level Supplemental Logging See Also:Querying Views for Supplemental Logging Settings Database-Level Supplemental Logging There are two types of database-level supplemental logging: minimal supplemental lo
alter database drop supplemental log data (primary key,unique index) columns; alter table test add supplemental log data (primary key,unique index) columns; update test set t2=’ZZZZZ’; commit; 使用LOGMNR工具查看redo中的SQL: update “SYS”.”TEST” set “T2” = ‘ZZZZZ’ where “T1” =...
If the table has neither a primary key nor a non-null unique index key, then all columns except LONG and LOB are supplementally logged; this is equivalent to specifying ALL supplemental logging for that row. Therefore, Oracle recommends that when you use database-level primary key supplemental...
alter database add supplemental log data; alter table Schema_name.Table_name add supplemental log data(primary key,unique) columns; NOTICE: Replace Schema_name.Table_name with the actual name. All Table-Level Supplemental Log Check Check whether supplemental logging of the table-level objects to...
(有条件) 仅当first_name或last_name被修改,重做记录才记录这两个字段的旧值altertablehr.employeesaddsupplemental loggroupemp_info(first_name,last_name);#启用表级自定义字段补充日志(无条件) 表的任意字段被修改,重做记录都会记录这两个字段的旧值altertablehr.employeesaddsupplemental loggroupemp_info(first_...
supplemental logging分为两个级别database_level and table_level,其中database_level级别分为两种,minimal supplemental logging and identification key logging,其中minimal supplemental logging不会显著增加系统的负担,但是identification key logging对系统负担比较大,在默认情况下oracle不会设置任何supplemental logging,但是...
SELECTsupplemental_log_data_minFROMv$database; 查询结果为YES或IMPLICIT,表示已打开。 执行下述语句,确认待同步表的表级别补偿日志是否打开。 SELECTlog_group_typeFROMall_log_groupsWHEREOWNER='<schema_name>'ANDtable_name='<table_name>'; 每种补偿日志返回一行,结果中需要包含ALL COLUMN LOGGING,或者PRIMARY ...
This is the minimum required schema-level logging. Table-level supplemental logging with built-in support for integrated Replicat See Enabling Table-level Supplemental Logging ADD TRANDATA Enables unconditional supplemental logging of the primary key and conditional supplemental logging of unique key(s)...
You can enable database-level supplemental logging to ensure the stability of DTS tasks. You can enable table-level supplemental logging to reduce the disk usage of the source Oracle database. If you select databases as the objects to be migrated, the tables that are created by using DDL sta...
Enable table-level supplemental logging on the schema: GGSCI>ADD SCHEMATRANDATA dms_sample Create an extract group to fetch incremental changes. The extract group name can be eight characters long and needs to be unique across a single configuration.TheDMS_SAMPLEschema is a s...