#Unique

ORA-00001: unique constraint violated异常处理

程序中保存数据时报错,ORA-00001:uniqueconstraint(xxxx)violated先是查看数据库结构,最近也没什么改动,开发环境也正常,测试环境就报这个错后来发现主键id是自增的,查询序列的下个值  selecttable_seq.nextval fromdual发现这...

ORA-16052: DB_UNIQUE_NAME attribute is required.

文档解释ORA-16052:DB_UNIQUE_NAMEattributeisrequired.Cause:DB_UNIQUE_NAMEattributewasnotspecified.ThevalueoftheLOG_ARCHIVE_DEST_nparameterforeachremoteredotransportd...

ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION

文档解释ORA-14130:UNIQUEconstraintsmismatchinALTERTABLEEXCHANGEPARTITIONCause:OneofthetablesnamedintheALTERTABLEEXCHANGEPARTITIONcommandhasaUNIQUEconstraintforwhich...

ORA-26027: unique index string.string partition string initially in unusable state

文档解释ORA-26027:uniqueindexstring.stringpartitionstringinitiallyinunusablestateCause:ApartitionofauniqueindexisinIUstate(auniqueindex*cannothaveindexmaintenancesk...

ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

文档解释ORA-16195:DG_CONFIGrequiresDB_UNIQUE_NAMEbeexplicitlydefinedCause:TheDG_CONFIGattributeoftheLOG_ARCHIVE_CONFIGparametercanonlybeusediftheDB_UNIQUE_NAMEparam...

ORA-40390: PMML DerivedField must have a unique name specified: string

文档解释ORA-40390:PMMLDerivedFieldmusthaveauniquenamespecified:stringCause:ADerivedFielddidnotreferenceanotherdefinedfield.Action:ADerivedFielddidnothaveauniquename...

ORA-38911: unique constraint (string.string) violated

文档解释ORA-38911:uniqueconstraint(string.string)violatedCause:AnINSERTstatementwithaCHANGE_DUPKEY_ERROR_INDEXhinttriedtoinsertaduplicatekeyintoatable.Action:Either...

ORA-41611: rule identifier “string” not unique in the rule class

文档解释ORA-41611:ruleidentifier“string”notuniqueintheruleclassCause:Anattemptwasmadetouseaduplicateruleidentifier.Action:Chooseauniqueidentifierforther...

ORA-39228: Unable to construct a unique departitioned object name for string string.string:string when defaulted.

文档解释ORA-39228:Unabletoconstructauniquedepartitionedobjectnameforstringstring.string:stringwhendefaulted.Cause:All(sub)partitionsinthejobweretobecreatedasindivid...

ORA-14064: Index with Unusable partition exists on unique/primary constraint key

文档解释ORA-14064:IndexwithUnusablepartitionexistsonunique/primaryconstraintkeyCause:Userattemptedtoaddorenableaprimarykey/uniqueconstraintoncolumn(s)ofatableonwhic...

ORA-16745: unable to add DB_UNIQUE_NAME “string” into the DG_CONFIG list because it is full

文档解释ORA-16745:unabletoaddDB_UNIQUE_NAME“string”intotheDG_CONFIGlistbecauseitisfullCause:TheDG_CONFIGlistoftheLOG_ARCHIVE_CONFIGattributewasfullandth...
IT技术学习 ·2023-07-19

ORA-38914: Either mutate the error or ignore row on unique violation

文档解释ORA-38914:EithermutatetheerrororignorerowonuniqueviolationCause:IGNORE_ROW_ON_DUPKEY_INDEXandCHANGE_DUPKEY_ERROR_INDEXwerebothspecifiedinthesamestatement.Ac...

ORA-14063: Unusable index exists on unique/primary constraint key

文档解释ORA-14063:Unusableindexexistsonunique/primaryconstraintkeyCause:Userattemptedtoaddorenableaprimarykey/uniqueconstraintoncolumn(s)ofatableonwhichthereexistsa...

ORA-30346: hierarchy name must be unique within a dimension

文档解释ORA-30346:hierarchynamemustbeuniquewithinadimensionCause:Thesamenamewasusedformorethanonehierarchyinadimension.Action:Checkthespellingofthehierarchyname.ORA...

ORA-14131: enabled UNIQUE constraint exists on one of the tables

文档解释ORA-14131:enabledUNIQUEconstraintexistsononeofthetablesCause:OneofthetablesreferencedintheALTERTABLEEXCHANGEPARTITION|SUBPARTITIONstatementhasenabledUNIQUEc...
首页上一页12345...下一页尾页