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!

extract abended

ARUN-ASep 8 2016 — edited Sep 9 2016

Hi Experts,

We have gg set up between one to many oracle databases with only DML replication , its running fine for couple of years,today Suddenly all the extract process abended with below error ,

We did one change last week in one of the table , like we have dropped one of the column and recreated the same column with different datatype. But that column is not a primary key of that table

Like initially the col id was number then we have dropped that id column and and recreated with varchar data type.

Also in extract parameter we have used COLS parameter and we are sending limitted columns for some of the target database.

Also , after changed two days its works fine and replicated the data.

ERROR OGG-00665 OCI Error NlscharSetConvert error charsetId 2000 to UTF-16 for col TYPE (status = 1403-ORA-01403: no data found), SQL<Not available>

Please help to resolve this

Database version : 11.2.0.4

OGG version : 11.2

Thanks,

This post has been answered by ARUN-A on Sep 8 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2016
Added on Sep 8 2016
12 comments
1,916 views