Multiple schemas to be replicated
edited Aug 17, 2012 5:02PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Dear experts
I've 2 schemas appluser1 and appluser2 to be replicated. from 10g to 11g, How do I include ddl for those 2 schemas only . Following is my extract parameter file.
--------------------------------------------------------------------------------
extract ext1
userid gguser, password gguser
--hostname and port for trail--
-- rmthost oracle11g, mgrport 7809
--path and name for trail--
exttrail /oracle/home/gg/datdir/lt
--DDL support
--DML
table appluser1.*;
table appluser2.*;
----------------------------------------------------------------------------------
Thanx in advance
0