Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DDL Replicate Oracle 10gR2 to SQL Server 2005

AndesApr 18 2012 — edited Apr 19 2012
Dear Gurus,

I have configured OGG and it had succeed to have DML transaction from Oracle to SQL Server.
now i'm configuring DDL replication but have problem when i tried to start replicat program in SQL Server 2005, the status is abended.
the log shows as below,

***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT rora01
sourcedb dsn_ncli, userid ggs_user, password ********

2012-04-17 18:02:20 INFO OGG-01552 Connection String: provider=SQLNCLI;init
ial catalog=gate;data source=BT-70CF7B38342B;user id=ggs_user;password= ********
.
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/rora01.dsc, PURGE
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
MAP hr.*, TARGET ggs_schema.*;

...

2012-04-17 18:02:20 ERROR OGG-00899 Table GGS_SCHEMA.GGS_SETUP does not exist.

Fyi, in hr schema in source database, GGS_SETUP is created after i Install GoldenGate DDL objects in source db. GGS_SCHEMA is schema that replicat schema in target database.

Please help what should i add in replicat parameter to have this DDL works ?

Regards,
Andes

Edited by: 915856 on Apr 17, 2012 10:16 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2012
Added on Apr 18 2012
3 comments
293 views