#referential

ORA-22896: cannot have both scope and referential constraint on REF column “string”

文档解释ORA-22896:cannothavebothscopeandreferentialconstraintonREFcolumn“string”Cause:REFcolumnhasbothareferentialandascopeconstraint.Areferentialconstr...

ORA-14455: attempt to create referential integrity constraint on temporary table

文档解释ORA-14455:attempttocreatereferentialintegrityconstraintontemporarytableCause:Anattemptwasmadetocreateareferentialintegrityconstraintonatemporarytable.Thisis...

ORA-30730: referential constraint not allowed on nested table column

文档解释ORA-30730:referentialconstraintnotallowedonnestedtablecolumnCause:Anattemptwasmadetodefineareferentialconstraintonanestedtablecolumn.Action:Donotspecifyrefe...

ORA-30727: duplicate referential constraint for a REF column

文档解释ORA-30727:duplicatereferentialconstraintforaREFcolumnCause:MultiplereferentialconstraintswerespecifiedforasingleREFcolumn.Action:Removetheduplicatereferenti...

ORA-39803: Data saves are not allowed on tables with partitioning referential constraints.

文档解释ORA-39803:Datasavesarenotallowedontableswithpartitioningreferentialconstraints.Cause:Datasaves(andthesqlldrROWSparameter)arenotallowedwhenloadingboththepare...
IT技术学习 ·2023-07-13

ORA-14454: attempt to reference temporary table in a referential integrity constraint

文档解释ORA-14454:attempttoreferencetemporarytableinareferentialintegrityconstraintCause:Anattemptwasmadetoreferencetemporarytableinareferencialintegrityconstraint....

ORA-54036: cannot define referential constraint with ON DELETE SET NULL clause on virtual column

文档解释ORA-54036:cannotdefinereferentialconstraintwithONDELETESETNULLclauseonvirtualcolumnCause:AttemptedtospecifyONDELETESETNULLclauseforareferentialintegritycons...

ORA-38822: referential integrity constraints not allowed on editioned views

文档解释ORA-38822:referentialintegrityconstraintsnotallowedoneditionedviewsCause:Anattemptwasmadetocreateareferentialintegrityconstrainttoorfromaneditionedvieworena...

ORA-30771: Cannot add more than one referential constraint on REF column “string”

文档解释ORA-30771:CannotaddmorethanonereferentialconstraintonREFcolumn“string”Cause:MultiplereferentialconstraintswerespecifiedforasingleREFcolumn.Actio...
IT技术学习 ·2023-07-09

ORA-02274: duplicate referential constraint specifications

文档解释ORA-02274:duplicatereferentialconstraintspecificationsCause:Self-evident.Action:Removetheduplicatespecification.。ORA-02274说明在两个参考约束日志之间重复了一些语句,导致系统在编译它们时出现了...

ORA-22898: existing scope clause on “string” points to a table other than the one mentioned in the referential constraint

文档解释ORA-22898:existingscopeclauseon“string”pointstoatableotherthantheonementionedinthereferentialconstraintCause:Tablementionedinthereferentialinteg...

ORA-02275: such a referential constraint already exists in the table

文档解释ORA-02275:suchareferentialconstraintalreadyexistsinthetableCause:Self-evident.Action:Removetheextraconstraint.ORA-02275错误显示在您尝试为现有表定义另一个具有同样名称的外部键约束时。Oracle...

ORA-02444: Cannot resolve referenced object in referential constraints

文档解释ORA-02444:CannotresolvereferencedobjectinreferentialconstraintsCause:attemptedtodefineforeignkeyreferencinganobjectwhichcannotberesolvedtoabasetablereferenc...

ORA-02440: Create as select with referential constraints not allowed

文档解释ORA-02440:CreateasselectwithreferentialconstraintsnotallowedCause:createtablefoo(…ref.con.…)asselect…;Action:Createthetableasselect,thenal...