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!

Sequence Nextval not updating in target schema

samiFeb 13 2014 — edited Feb 14 2014

Hi All,

Am using Golden gate

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

Windows (optimized), Oracle 10g on Oct 5 2011 00:50:35

configured DDL options to replicate changes from scott schema to scott1 schema

DDL statements are working fine. such as create, alter, rename.

Even DML statement with sequence also working fine.

But sequence next value is not updating from schema scott to scott1. (No errors in log files)

I have executed sequence.sql on both database schemas( for Golden Gate schema).

Please help me to resolve the above issue

Thanks & Regards

Sami

This post has been answered by sami on Feb 14 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2014

Added on Feb 13 2014

#goldengate

4 comments

2,917 views