Hi OGG EXPERTS,
I can configure OGG Oracle to Oracle.
At some-point i need more clarity. Please help me to understand bit clearly.
MY_REF_LINK : http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/orcl_orcl/index.html
GGSCI (AUSDEV) 1> info trandata scott.emp
Logging of supplemental redo log data is disabled for table SCOTT.EMP.
GGSCI (AUSDEV) 2> add trandata scott.emp
Logging of supplemental redo data enabled for table SCOTT.EMP.
GGSCI (AUSDEV) 3> info trandata scott.emp
Logging of supplemental redo log data is enabled for table SCOTT.EMP.
Table scott.emp is having Primary key (empno).
Simply i know, OGG takes reference key as empno column. But i want to know,
1) What happens internally/exactly at that time of enabling table level Supplemental Logging ?
GGSCI> add trandata scott.emp
2) What happens internally/exactly at that time of enabling DB Level Supplemental Logging ?
3) Why Oracle Goldengate needs Row Chaining Information ? - Highly Confused.
SQL> alter database add supplemental log data
I know minimal information as per Oracle docs.
I am NOT satisfied with the insufficient information from docs and complex to understand the concept perfectly.
Please discuss elaborately. It would help to many folks.
Thanks in advance.