Error ORA-00001 Unique Constraint When Re-applying Service Packs (Doc ID 1562709.1)

Last updated on JUNE 21, 2013

Applies to:

Goal

When we run CDXPatch.exe with the '-k' parameter, we are seeing several unique constraint errors.


e.g.

--ERROR: ORA-00001: unique constraint (CISADM.SYS_C008392) violated (DBD ERROR: OCIStmtExecute)occured while executing INSERT INTO CI_MD_PRG_COM(PROG_COM_ID,LOC_ID,TBL_NAME,PROG_COM_NAME,TMPL_CD,DEV_STATUS_FLG,COMMENT_LONG,COMMENT_SHORT,PROG_COM_TYPE_FLG,OWNER_FLG) VALUES ('CI2       ','utilcode  ','CI_MD_PRG_COM                 ','metaDataProgComSearchPage','UIXSP   ','  ',' ',' ','    ','F1  ')
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.