topic Underlying DBMS error ORA-00001: unique constraint violated sde10 in Data Management Questions https://community.esri.com/t5/data-management-questions/underlying-dbms-error-ora-00001-unique-constraint/m-p/302826#M17345 <HTML><HEAD></HEAD><BODY><SPAN>Hi:</SPAN><BR /><BR /><SPAN>I have a database Oracle 11g and sde 10, when I try register my table:</SPAN><BR /><BR /><SPAN>sdelayer -o register -l MIN_GEOM,GEOM -e a -C GID_SDO -t SDO_GEOMETRY -s server -D database -u user -p passwd -P 32</SPAN><BR /><BR /><SPAN>Show me a error</SPAN><BR /><BR /><SPAN>ArcSDE 10.0&nbsp; for Oracle11g Build 685 Fri May 14 12:05:43&nbsp; 2010</SPAN><BR /><SPAN>Layer&nbsp;&nbsp;&nbsp; Administration Utility</SPAN><BR /><SPAN>-----------------------------------------------------</SPAN><BR /><SPAN>Error: Underlying DBMS error (-51).</SPAN><BR /><SPAN>Error: Unable to create registration for table MIN_GEOM.</SPAN><BR /><SPAN>ORA-00001: unique constraint (CRMDES.MIN_GEOM_PK) violated</SPAN><BR /><SPAN>ORA-06512: at line 1</SPAN><BR /><BR /><SPAN>My primary is correct in oracle, constraint pk is enable.</SPAN><BR /><BR /><BR /><SPAN>Could you help me please?</SPAN><BR /><BR /><SPAN>Thanks </SPAN><BR /><BR /><SPAN>Patty Mora</SPAN></BODY></HTML> Thu, 20 Jan 2011 19:16:36 GMT PatriciaMora 2011-01-20T19:16:36Z Underlying DBMS error ORA-00001: unique constraint violated sde10 https://community.esri.com/t5/data-management-questions/underlying-dbms-error-ora-00001-unique-constraint/m-p/302826#M17345 <HTML><HEAD></HEAD><BODY><SPAN>Hi:</SPAN><BR /><BR /><SPAN>I have a database Oracle 11g and sde 10, when I try register my table:</SPAN><BR /><BR /><SPAN>sdelayer -o register -l MIN_GEOM,GEOM -e a -C GID_SDO -t SDO_GEOMETRY -s server -D database -u user -p passwd -P 32</SPAN><BR /><BR /><SPAN>Show me a error</SPAN><BR /><BR /><SPAN>ArcSDE 10.0&nbsp; for Oracle11g Build 685 Fri May 14 12:05:43&nbsp; 2010</SPAN><BR /><SPAN>Layer&nbsp;&nbsp;&nbsp; Administration Utility</SPAN><BR /><SPAN>-----------------------------------------------------</SPAN><BR /><SPAN>Error: Underlying DBMS error (-51).</SPAN><BR /><SPAN>Error: Unable to create registration for table MIN_GEOM.</SPAN><BR /><SPAN>ORA-00001: unique constraint (CRMDES.MIN_GEOM_PK) violated</SPAN><BR /><SPAN>ORA-06512: at line 1</SPAN><BR /><BR /><SPAN>My primary is correct in oracle, constraint pk is enable.</SPAN><BR /><BR /><BR /><SPAN>Could you help me please?</SPAN><BR /><BR /><SPAN>Thanks </SPAN><BR /><BR /><SPAN>Patty Mora</SPAN></BODY></HTML> Thu, 20 Jan 2011 19:16:36 GMT https://community.esri.com/t5/data-management-questions/underlying-dbms-error-ora-00001-unique-constraint/m-p/302826#M17345 PatriciaMora 2011-01-20T19:16:36Z