Reset Sequence Value After Full Synch Becomes Null

(Doc ID 311475.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.0.0.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***

Symptoms

After a full synch the CURR_VAL field for the user is NULL in

Mobileadmin.C$SEQ_CLIENTS

How to reproduce the scenario :

1.create a table for_seq_test ( ID,name)
2.create a application
3.insert some sequences into for_seq_test
4.make a sync
5.check mobileadminC$seq_client and cur_value
6.drop the database folder side client
7.Do a sync without change datas side client
8.Do a sync again , the cur_value side client is set to a wrong value.
In fact takes first value from the seq window

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms