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...
Database-Level Supplemental Logging Table-Level Supplemental Logging See Also:Querying Views for ...
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 tableSchema_name.Table_nameadd supplemental log data(primary key,unique) columns; ReplaceSchema_name.Table_namewith the actual name. All Table-Level Supplemental Log Check Check whether supplemental logging of the table-level objects to be synchronized meets the requirements. Run the following ...
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” = ‘TEST’ and “T2” = ‘AAAAA’ and “T3” = ‘TEST’……… ...
Supplemental Logging又被分为两个级别的,Database-Level Supplemental Logging和Table-Level Supplemental Logging。这个很好理解,一个是整库的设置,一个是特定的设置,比较简单,不详述。 Database-Level Supplemental Logging中又分成两种 …… Minimal Supplemental Logging,顾名思义,也就是对当前的redo log做一个最小...
(有条件) 仅当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,但是...
this privilege can be removed. Alternatively, edit the script file to use a database user with this privilege. When the OGG database user is originally created, theALTER ANY TABLEprivilege is granted at that time. Once the script to enable table level supplemental logging completes, this privil...
lower-case-table-names = 1 OGG 复制进程需要该参数设置为 1,tidb 中修改此参数并未产生实际效果变化,仅为实现兼容。 5. OGG 同步要求 DDL 建表语句需提前转换,并在目标端执行。 如下表的示例: 源端Oracle create table account ( account_number number(10,0), account_balance decimal(38,2), account_...