–20170731 23:17:00
1.You must have the EXECUTE_CATALOG_ROLE role to use the DBMS_CDC_PUBLISH package;
2.change data capture:
http://docs.oracle.com/cd/E11882_01/server.112/e25554/cdc.htm#DWHSG016
3.
GoldenGate support Oracle change Data Capture.
Synchronous Change Data Capture is available with Oracle Standard Edition and Enterprise Edition。
There are three modes of asynchronous Change Data Capture: HotLog, Distributed HotLog, and AutoLog