How to replicate – Create User, Procedure and Tablespace using Oracle GoldenGate.
I am able to replicate DDL under schema, however above is not getting replicated i.e. when I create an user, procedure or tablespace.
GoldenGate Version – 12.2.0.1
Database Version – 11.2.0.4
Extract Conf:
GGSCI (sourceGG) 36> view params ext4
extract ext4
userid ogguser, password ogguser
exttrail /u01/app/oracle/product/11.2.0.4/oggsrc/dirdat/mt
DDL INCLUDE ALL
table ogguser.*;
GGSCI (sourceGG) 37>
Dump Conf:
GGSCI (sourceGG) 37> view params dpump2
extract dpump2
userid ogguser, password ogguser
rmthost targetGG, mgrport 7809
rmttrail /u01/app/oracle/product/11.2.0.4/oggtrg/dirdat/pt
passthru
DDL INCLUDE ALL
table ogguser.*;
GGSCI (sourceGG) 38>
Replicat Conf:
GGSCI (targetGG) 37> view params rep4
replicat rep4
assumetargetdefs
handlecollisions
userid ogguser, password ogguser
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
map ogguser.*, target ogguser.*;
GGSCI (targetGG) 38>
Thanks!
Best Answer
DDL replication in Oracle Goldengate is disabled for the extract process by default and enabled for the replicat process.
To enable the DDL support, you need to specify the DDL parameter for the extract process.
In order to replicate
CREATE USER
,ALTER TABLESPACE
orCREATE ROLE
kind of statement the DDL scope should beOTHER
orALL
to include all kind of DDLs.Some other examples of
OTHER
scope:References: