oracle enable LogMiner 1. Enable LogMiner shutdown immediate;startup mount;alter database archivelog;alter databaseopen; 2. Enable Supplemental Logging For 12c multitenant databases ALTERSESSIONSETCONTAINER=<pdb>; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;ALTER TABLE XW_IFP.UM_LOCAL_USER ADD SUPPLEMEN...
Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1) enableSupplementalLogging for a CLOB column, either with theGoldenGateADDTRANDATAcommand or... KEYCOLS clause. To make those columns available toGoldenGate, they must be logged to theRedoLogby ...
/dirdat/e2 table lhr.*; 创建replicate进程 代码语言:javascript 复制 REPLICAT rep12c USERIDALIAS ora12c DOMAIN OGGMA DDL INCLUDE MAPPED DDLOPTIONS REPORT DBOPTIONS SETTAG MAP lhr.*, TARGET lhr.*; 测试DDL和DML同步 在Oracle 21c操作: 代码语言:javascript 复制 create table t2 (id number ...
SQL> conn receiver/oracle Connected. SQL> create table handlec(t1 int primary key,t2 int); Table created. SQL> insert into handlec values(1,2); 1 row created. SQL> commit; SQL> select * from handlec; T1 T2 --- --- 1 2 SQL> GGSCI (XIANGBLI-CN) 1> alter extract load2 , be...