INDEXES主题的文章列表，还有INDEXES的技术要点_第2页

ORA-38915: Multiple indexes in change or ignore duplicate key hint

文档解释ORA-38915:MultipleindexesinchangeorignoreduplicatekeyhintCause:MultipleindexeswerespecifiedinanIGNORE_ROW_ON_DUPKEY_INDEXorCHANGE_DUPKEY_ERROR_INDEXhint.Act...

IT技术学习 ·2023-07-16

ORA-28602: statement not permitted on tables containing bitmap indexes

文档解释ORA-28602:statementnotpermittedontablescontainingbitmapindexesCause:tablehasbitmapindexesanduserisminimizingornominimizingrecords_per_blockAction:dropallbit...

IT技术学习 ·2023-07-11

ORA-10664: Table has bitmap join indexes

文档解释ORA-10664:TablehasbitmapjoinindexesCause:SHRINKwasissuedonatablewithbitmapjoinindexes.Action:DropbitmapjoinindexesandreissueSHRINKontheobject.ORA-10664表示你尝试...

IT技术学习 ·2023-07-11

ORA-55336: insufficient privileges for using one or more of the models and rules indexes

文档解释ORA-55336:insufficientprivilegesforusingoneormoreofthemodelsandrulesindexesCause:Anattemptwasmadetocreateavirtualmodelwithouttheappropriateprivileges.Action...

IT技术学习 ·2023-07-11

ORA-29850: invalid option for creation of domain indexes

文档解释ORA-29850:invalidoptionforcreationofdomainindexesCause:TheuserspecifiedaninvalidoptionlikeASC,DESC,SORToraparallelclause,partitioningclauseorphysicalattribu...

IT技术学习 ·2023-07-11

ORA-14325: only LOCAL indexes may be specified in this clause

文档解释ORA-14325:onlyLOCALindexesmaybespecifiedinthisclauseCause:AglobalindexhasbeenspecifiedintheUPDATEINDEXES(..)clauseAction:Onlyspecifylocalindexeswhenusingthi...

IT技术学习 ·2023-07-11

ORA-55453: OLS/VPD-enabled indexes must be created with CREATE_ENTAILMENT API

文档解释ORA-55453:OLS/VPD-enabledindexesmustbecreatedwithCREATE_ENTAILMENTAPICause:AnattemptwasmadetocreateentailmentforOLS/VPD-enabledmodelsusingunsupportedAPI.Act...

IT技术学习 ·2023-07-11

ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

文档解释ORA-26001:IndexstringspecifiedinSORTEDINDEXESdoesnotexistontablestringCause:AnonexistentindexwasspecifiedintheSORTEDINDEXESclause.Action:DonotspecifyasaSORT...

IT技术学习 ·2023-07-11

ORA-02001: user SYS is not permitted to create indexes with freelist groups

文档解释ORA-02001:userSYSisnotpermittedtocreateindexeswithfreelistgroupsCause:usertriedtocreateanindexwhilerunningwithsysauthorization.Action:None此错误消息表明，ORACLE不允许用...

IT技术学习 ·2023-07-09

ORA-29886: feature not supported for domain indexes

文档解释ORA-29886:featurenotsupportedfordomainindexesCause:Featureisnotsupportedfordomainindexes.Action:Noactionrequired.ORA-29886错误是一种Oracle数据库错误，提示用户不支持域索引。官方解释常见...

IT技术学习 ·2023-07-09

ORA-14134: indexes cannot use both DESC and REVERSE

文档解释ORA-14134:indexescannotusebothDESCandREVERSECause:AnattemptwasmadetomakeareverseindexwithsomeindexcolumnsmarkedDESC.Action:DonotuseDESCinreverseindexes.Ther...

IT技术学习 ·2023-07-09

ORA-29853: keyword UNIQUE may not be used in creating domain indexes

文档解释ORA-29853:keywordUNIQUEmaynotbeusedincreatingdomainindexesCause:AnattemptwasmadetocreateadomainindexwiththeUNIQUEattribute.Action:RemoveUNIQUEfromtheCREATEI...

IT技术学习 ·2023-07-08

ORA-14506: LOCAL option required for partitioned indexes

文档解释ORA-14506:LOCALoptionrequiredforpartitionedindexesCause:IncorrectsyntaxspecifiedAction:Retrythecommand此错误代码指示在创建分区索引时未指定LOCAL选项。索引必须被指定为“LOCAL”才能被分区。官方解释“OR...

IT技术学习 ·2023-07-08

ORA-30957: cannot downgrade because there are XML indexes

文档解释ORA-30957:cannotdowngradebecausethereareXMLindexesCause:AnattemptwasmadetodowngradeadatabasethathasXMLindexes.Action:DropallXMLindexesbeforeattemptingthedow...

IT技术学习 ·2023-07-08

ORA-29918: cannot create domain indexes on temporary tables

文档解释ORA-29918:cannotcreatedomainindexesontemporarytablesCause:AnattemptwasmadetocreateadomainindexonatemporarytableAction:Eithercreateanothertypeofindexonthetem...

IT技术学习 ·2023-07-08