Unable to Create Sequence in Oracle DB

Sometimes CREATE SEQUENCE may not work in Oracle data base when the replication is run. In such cases sync_id will not be created. Hence an error will generate after running replication.

Solution:

This issue can be resolved by executing the following query in Oracle data base before running the replication. This query will create sequence hence create sync_id.

CREATE SEQUENCE  "DBSYNC"."SYNCH_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

CREATE SEQUENCE  "DBSYNC"."NEXTVAL"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;