HOW TO
Moving the Enterprise database back from the RAC (clustered environment) to a non-clustered environment only involves resetting the 'sde.state_id_generator_nc' sequence.
To migrate an Enterprise database back to a non-clustered environment from an RAC environment, update the state_id_generator_nc sequence as follows:
Code: BEGIN DECLARE STATE_ID_MAX NUMBER := 0; SEQ_VAL NUMBER := 0; L_DIFF NUMBER := 0; BEGIN SELECT MAX (STATE_ID) INTO STATE_ID_MAX FROM STATES; SELECT state_id_generator_nc.NEXTVAL INTO SEQ_VAL FROM DUAL; IF SEQ_VAL < STATE_ID_MAX then L_DIFF := STATE_ID_MAX - SEQ_VAL; EXECUTE IMMEDIATE 'ALTER SEQUENCE state_id_generator_nc INCREMENT BY ' || L_DIFF; SELECT state_id_generator_nc.NEXTVAL INTO SEQ_VAL FROM DUAL; EXECUTE IMMEDIATE 'ALTER SEQUENCE state_id_generator_nc INCREMENT BY 1' ; END IF; END; END;
Get help from ArcGIS experts
Download the Esri Support App