Which OGG process (es) can change data in database?
A.
Replicat only
B.
Extract only
C.
Extract and Replicat
D.
Extract, Replicat and Manager
Explanation:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Which OGG process (es) can change data in database?
Which OGG process (es) can change data in database?
A.
Replicat only
B.
Extract only
C.
Extract and Replicat
D.
Extract, Replicat and Manager
Explanation:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
answer should be A
I haven’t see any use case where extract need to change the data on database.
moreover, review the Goldengate database user setup – oracle does not ask for insert/update/delete on tables to gg_user.
A is the answer
Ans: A
C is correct, you can run sqlexec from extract!