Data is synchronizing from source to target with “No records were replicated”
edited Feb 3, 2016 9:26AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓
Environment:
Source: Oracle:11.2.0.1 on Linux x64
Target: SQLServer:2005 on Windows 2008R2 x64
OGG:12.1.2.1.0
I was trying to sync data from Oracle to SQL Server. After the successful execution of extract process in the source server, there are no errors are reported and no records were replicated. My data at source includes format of BLOB and CLOB which converts to image and ntext format at target side.
Really appreciate some kindly helps!
From Source prm file:
EXTRACT bullinx
USERIDALIAS ogg
RMTHOST xx.xx.xx.xx, MGRPORT 7809
RMTTRAIL ./dirdat/bi
TABLE center_admin.blt_bulletinannex;
From source extract report:
From Target prm file:
Tagged:
1