OGG Oracle Golden Gate

GGSCI
--connect to Oracle database
DBLOGIN USERID owner@TESTDB, PASSWORD owner_pass
Successfully logged into database.
--show status
info all

Stat by tables
STATS EXTRACT e*, TABLE <schema>.<table>
STATS REPLICAT r*, TABLE <schema>.<table>






Metalink
How to add new tables for OGG replication in the current running extract and replicat  [ID 1332674.1]
GoldenGate Support of INSERT + APPEND_VALUES  Hint [ID 1391897.1]
OGG How to address Extract Performance Issue When Reading Archive Logs stored in Oracle ASM [ID 1363266.1]
Oracle GoldenGate - Best Practice - Extract ASM Connection Methods [ID 1390268.1]

Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...