REPLACE GIS MaxObjectID p_owner VARCHAR2 p_tablename VARCHAR2 NUMBER
SDE TABLE_REGISTRY tr
tr OWNER p_owner tr TABLE_NAME p_tablename
vc2SqlStr : p_owner p_tablename
IMMEDIATE vc2SqlStr max_objectid
max_objectid WS A658 objectid :
max_objectid : GIS MaxObjectID
max_objectid :new eid :new objectid max_objectid
HYDRANT_EID_SEQ NEXTVAL :NEW EID DUAL
I'm not familiar with SDE in Oracle so I can't comment specifically on that.
However, I can tell you that an OBJECTID is not guaranteed to be larger than the previously added record. If multiple processes are writing to the table, one process could reserve a slice of OBJECTIDs for itself. Then, if a second process starts adding records before the first one is done, the lower OBJECTIDs of the first process will be intermixed with the higher OBJECTIDs of the second process.